/*
 Navicat Premium Data Transfer

 Source Server         : localhost docker
 Source Server Type    : MySQL
 Source Server Version : 50651
 Source Host           : localhost:3306
 Source Schema         : jeepay2023

 Target Server Type    : MySQL
 Target Server Version : 50651
 File Encoding         : 65001

 Date: 13/08/2023 22:39:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for balance
-- ----------------------------
DROP TABLE IF EXISTS `balance`;
CREATE TABLE `balance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `balance_type` int(2) NOT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `balance` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '可用余额',
  `total_balance` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '总金额',
  `released_balance` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '已解冻余额',
  `blocked_balance` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '已冻结金额',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='钱包';

-- ----------------------------
-- Table structure for balance_log
-- ----------------------------
DROP TABLE IF EXISTS `balance_log`;
CREATE TABLE `balance_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `balance_id` int(11) DEFAULT NULL COMMENT '账本标识',
  `balance_type` int(11) DEFAULT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `balance` decimal(25,4) DEFAULT NULL COMMENT '增加或减少的钱',
  `old_balance` decimal(25,4) DEFAULT '0.0000' COMMENT '上次金额',
  `new_balance` decimal(25,4) DEFAULT '0.0000' COMMENT '上次金额',
  `source_type` int(2) DEFAULT '0' COMMENT '//来源类型\r\n1,会员转帐 2交易卖出,3交易买入 4兑换',
  `log_type` int(2) DEFAULT NULL COMMENT '日志类型（增加1、减少0）',
  `source_id` bigint(20) DEFAULT NULL COMMENT '如果来源为订单，即为订单id,如果来源为分红，则为分红日志id',
  `handle_time` tinyint(1) NOT NULL DEFAULT '0' COMMENT '到账时间 0-to 1-t1',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `bonus_from` varchar(64) DEFAULT NULL COMMENT '分红的来源',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='账本日志表';

-- ----------------------------
-- Table structure for balance_operate
-- ----------------------------
DROP TABLE IF EXISTS `balance_operate`;
CREATE TABLE `balance_operate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '会员ID',
  `member_user_name` varchar(32) DEFAULT NULL COMMENT '姓名',
  `amount` decimal(25,4) DEFAULT NULL COMMENT '金额',
  `balance_type` tinyint(4) DEFAULT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `type` int(2) DEFAULT NULL COMMENT '日志类型（增加1、减少0）',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='账本操作';

-- ----------------------------
-- Table structure for balance_type
-- ----------------------------
DROP TABLE IF EXISTS `balance_type`;
CREATE TABLE `balance_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '会员ID',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '账本类型',
  `type_name` varchar(32) NOT NULL COMMENT '账本类型名称',
  `code` varchar(32) NOT NULL COMMENT '货币英文编码',
  `symbol` varchar(32) NOT NULL COMMENT '货币符号',
  `is_tixian` char(1) NOT NULL DEFAULT '0' COMMENT '能否提现',
  `is_transfer` char(1) DEFAULT '0' COMMENT '能否转账',
  `is_exchange` char(1) DEFAULT '0' COMMENT '能否兑换',
  `is_recharge` char(1) DEFAULT '0' COMMENT '能否充值',
  `price` decimal(25,4) NOT NULL DEFAULT '1.0000' COMMENT '账本的价格（对人民币汇率）',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='账本类型表';

-- ----------------------------
-- Table structure for pay_admin
-- ----------------------------
DROP TABLE IF EXISTS `pay_admin`;
CREATE TABLE `pay_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `user_name` varchar(64) NOT NULL COMMENT '后台用户名',
  `password` varchar(64) NOT NULL COMMENT '后台用户密码',
  `group_id` tinyint(1) unsigned DEFAULT '0' COMMENT '用户组',
  `google_secret_key` varchar(128) NOT NULL DEFAULT '' COMMENT '谷歌令牌密钥',
  `mobile` varchar(256) NOT NULL DEFAULT '' COMMENT '手机号码',
  `session_random` varchar(64) NOT NULL DEFAULT '' COMMENT 'session随机字符串',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Table structure for pay_agent_category
-- ----------------------------
DROP TABLE IF EXISTS `pay_agent_category`;
CREATE TABLE `pay_agent_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL COMMENT '等级名',
  `sort` tinyint(4) DEFAULT NULL COMMENT '排序',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代理分类表';

-- ----------------------------
-- Table structure for pay_agent_reconciliation
-- ----------------------------
DROP TABLE IF EXISTS `pay_agent_reconciliation`;
CREATE TABLE `pay_agent_reconciliation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT '0' COMMENT '用户ID',
  `order_total_count` int(11) DEFAULT '0' COMMENT '总订单数',
  `order_success_count` int(11) DEFAULT '0' COMMENT '成功订单数',
  `order_fail_count` int(11) DEFAULT '0' COMMENT '未支付订单数',
  `order_total_amount` decimal(25,4) DEFAULT '0.0000' COMMENT '订单总额',
  `order_success_amount` decimal(25,4) DEFAULT '0.0000' COMMENT '订单实付总额',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代理对账表';

-- ----------------------------
-- Table structure for pay_auto_df_log
-- ----------------------------
DROP TABLE IF EXISTS `pay_auto_df_log`;
CREATE TABLE `pay_auto_df_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `df_id` int(11) NOT NULL DEFAULT '0' COMMENT '代付ID',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型：1提交 2查询',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自动代付日志表';

-- ----------------------------
-- Table structure for pay_auto_unfrozen_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_auto_unfrozen_order`;
CREATE TABLE `pay_auto_unfrozen_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `freeze_money` decimal(25,4) NOT NULL DEFAULT '0.0000' COMMENT '冻结金额',
  `unfreeze_time` int(11) NOT NULL DEFAULT '0' COMMENT '计划解冻时间',
  `real_unfreeze_time` int(11) NOT NULL DEFAULT '0' COMMENT '实际解冻时间',
  `is_pause` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否暂停解冻 0正常解冻 1暂停解冻',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_unfreezeing` (`state`,`is_pause`,`unfreeze_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='投诉保证金余额';

-- ----------------------------
-- Table structure for pay_bank_card
-- ----------------------------
DROP TABLE IF EXISTS `pay_bank_card`;
CREATE TABLE `pay_bank_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商户编号',
  `bank_card_no` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  `bank_account` varchar(32) DEFAULT NULL COMMENT '户名',
  `bank_code` varchar(128) DEFAULT NULL COMMENT '银行编码',
  `ifsc` varchar(32) DEFAULT NULL COMMENT '印度支付必填(11位，第五位为0)',
  `mobile` varchar(256) DEFAULT NULL COMMENT '手机号',
  `email` varchar(256) DEFAULT NULL COMMENT '邮箱',
  `default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认 1是 0 否',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `bank_card_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='银行卡号';

-- ----------------------------
-- Table structure for pay_blocked_log
-- ----------------------------
DROP TABLE IF EXISTS `pay_blocked_log`;
CREATE TABLE `pay_blocked_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(128) NOT NULL COMMENT '订单号',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商户编号',
  `amount` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '冻结金额',
  `unfreeze_time` datetime DEFAULT NULL COMMENT '解冻时间',
  `pid` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '商户支付通道',
  `agent_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '代理号',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资金冻结待解冻记录';

-- ----------------------------
-- Table structure for pay_channel
-- ----------------------------
DROP TABLE IF EXISTS `pay_channel`;
CREATE TABLE `pay_channel` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '供应商通道ID',
  `code` varchar(200) DEFAULT NULL COMMENT '供应商通道英文编码',
  `title` varchar(200) DEFAULT NULL COMMENT '供应商通道名称',
  `balance_type` int(2) NOT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `merchant_no` varchar(100) DEFAULT NULL COMMENT '商户号',
  `sign_key` varchar(512) DEFAULT NULL COMMENT '签文密钥',
  `pay_gateway` varchar(256) NOT NULL DEFAULT ' ' COMMENT '请求支付地址',
  `page_return_url` varchar(256) DEFAULT NULL COMMENT '页面跳转网址',
  `notify_url` varchar(256) NOT NULL DEFAULT ' ' COMMENT '服务器通知网址',
  `default_rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '下家费率',
  `max_rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '封顶手续费',
  `rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '银行费率',
  `fixed_rate` int(10) NOT NULL DEFAULT '0' COMMENT '单笔固定手续费',
  `default_rate_t0` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT 'T0运营费率',
  `max_rate_t0` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT 'T0封顶手续费',
  `rate_t0` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT 'T0成本费率',
  `fixed_rate_t0` int(10) NOT NULL DEFAULT '0' COMMENT 't0固定收费值',
  `public_key` varchar(1024) DEFAULT NULL COMMENT '加密的公钥',
  `private_key` varchar(2048) DEFAULT NULL COMMENT '加密的私钥',
  `platform_public_key` varchar(1024) DEFAULT NULL COMMENT '平台公钥',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `query_gateway` varchar(256) NOT NULL DEFAULT ' ' COMMENT '查询支付地址',
  `agent_can_create_account` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代理是否可以上号',
  `start_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `paying_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '当天交易金额',
  `all_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '当天上游可交易量',
  `last_paying_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后交易时间',
  `min_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '单笔最小交易额',
  `max_money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '单笔最大交易额',
  `control_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '风控状态:0否1是',
  `offline_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '通道上线状态:0已下线，1上线',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='供应商列表';

-- ----------------------------
-- Table structure for pay_dict_group
-- ----------------------------
DROP TABLE IF EXISTS `pay_dict_group`;
CREATE TABLE `pay_dict_group` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `group_code` varchar(64) DEFAULT NULL COMMENT '组编码',
  `group_name` varchar(64) DEFAULT NULL COMMENT '组名',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据字典表';

-- ----------------------------
-- Table structure for pay_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `pay_dict_item`;
CREATE TABLE `pay_dict_item` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `group_code` varchar(64) DEFAULT NULL COMMENT '组编码',
  `item_code` varchar(64) DEFAULT NULL COMMENT '元素编码',
  `item_name` varchar(64) DEFAULT NULL COMMENT '元素名称',
  `sort` tinyint(4) DEFAULT NULL COMMENT '排序',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据字典元素表';

-- ----------------------------
-- Table structure for pay_global_conf
-- ----------------------------
DROP TABLE IF EXISTS `pay_global_conf`;
CREATE TABLE `pay_global_conf` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `conf_type` tinyint(4) DEFAULT '0' COMMENT '关系类型：0-通用 1-页面 2-api',
  `conf_code` varchar(64) DEFAULT NULL COMMENT '配置编码',
  `conf_name` varchar(64) DEFAULT NULL COMMENT '页面名称',
  `item_key` varchar(64) DEFAULT NULL COMMENT '配置key',
  `item_name` varchar(64) DEFAULT NULL COMMENT '配置名称',
  `item_value` varchar(4096) DEFAULT NULL COMMENT '配置内容',
  `item_desc` varchar(256) DEFAULT NULL COMMENT '描述',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='全局配置表';

-- ----------------------------
-- Table structure for pay_member
-- ----------------------------
DROP TABLE IF EXISTS `pay_member`;
CREATE TABLE `pay_member` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` tinyint(1) unsigned DEFAULT NULL COMMENT '用户组',
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '代理ID',
  `system_type` varchar(8) NOT NULL DEFAULT 'MCH' COMMENT '所属系统： MGR-运营平台admin, MCH-商户中心, AG-代理中心',
  `user_name` varchar(64) NOT NULL COMMENT '用户名',
  `salt` varchar(10) NOT NULL COMMENT '密码随机字符',
  `password` varchar(64) NOT NULL COMMENT '密码',
  `pay_password` varchar(32) DEFAULT NULL COMMENT '支付密码',
  `api_key` varchar(32) NOT NULL COMMENT 'APIKEY',
  `google_auth` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开启谷歌身份验证登录',
  `google_secret_key` varchar(255) NOT NULL DEFAULT '' COMMENT '谷歌密钥',
  `open_charge` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否开启充值功能',
  `df_api` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否开启代付API',
  `df_auto_check` tinyint(1) NOT NULL DEFAULT '1' COMMENT '代付API自动审核',
  `df_domain` varchar(512) NOT NULL DEFAULT '' COMMENT '代付域名报备',
  `df_ip` varchar(512) NOT NULL DEFAULT '' COMMENT '代付域名报备IP',
  `df_charge_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代付API扣除手续费方式，0：从到账金额里扣，1：从商户余额里扣',
  `path_id` varchar(256) DEFAULT '0,',
  `authorized` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0-未认证 1-已认证 2-待审核',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `session_random` varchar(50) NOT NULL DEFAULT '' COMMENT 'session随机字符串',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `can_create_account` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可以上号',
  `locked_money` decimal(25,4) DEFAULT '0.0000' COMMENT '锁定余额:场景 1-t1到账金额',
  `real_name` varchar(64) NOT NULL DEFAULT '' COMMENT '真实姓名',
  `mobile` varchar(64) NOT NULL DEFAULT '' COMMENT '手机号',
  `admin_flag` tinyint(6) NOT NULL DEFAULT '1' COMMENT '是否超管（超管拥有全部权限） 0-否 1-是',
  `agent_level` int(11) NOT NULL DEFAULT '7' COMMENT '代理级别',
  `unit_paying_number` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '单位时间已交易次数',
  `unit_paying_amount` decimal(21,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '单位时间已交易金额',
  `unit_frist_paying_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单位时间已交易的第一笔时间',
  `last_paying_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当天最后一笔已交易时间',
  `paying_money` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '当天已交易金额',
  `login_ip` varchar(255) NOT NULL DEFAULT ' ' COMMENT '登录IP',
  `last_error_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录错误时间',
  `login_error_num` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '错误登录次数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of pay_member
-- ----------------------------
BEGIN;
INSERT INTO `pay_member` VALUES (203, NULL, 0, 'MCH', '100005069', '7234', 'e10adc3949ba59abbe56e057f20f883e', 'e10adc3949ba59abbe56e057f20f883e', 'ds8dku4inn5l8iot4gta5mu3976118ls', 0, '', 1, 1, 1, '', '', 0, '0,', 1, NULL, 1, '2023-08-13 14:15:47', '2023-08-13 14:18:08', '', NULL, 0, 0.0000, '', '', 1, 7, 0, 0.0000, 0, 0, 0.0000, ' ', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for pay_member_rate
-- ----------------------------
DROP TABLE IF EXISTS `pay_member_rate`;
CREATE TABLE `pay_member_rate` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `pay_api_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '通道ID',
  `max_rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '封顶手续费',
  `rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '银行费率',
  `fixed_rate` int(10) NOT NULL DEFAULT '0' COMMENT '单笔固定手续费',
  `max_rate_t0` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT 'T0封顶手续费',
  `rate_t0` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT 'T0成本费率',
  `fixed_rate_t0` int(10) NOT NULL DEFAULT '0' COMMENT 't0固定收费值',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户费率表';

-- ----------------------------
-- Table structure for pay_member_reconciliation
-- ----------------------------
DROP TABLE IF EXISTS `pay_member_reconciliation`;
CREATE TABLE `pay_member_reconciliation` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `order_total_count` int(11) DEFAULT '0' COMMENT '总订单数',
  `order_success_count` int(11) DEFAULT '0' COMMENT '成功订单数',
  `order_fail_count` int(11) DEFAULT '0' COMMENT '未支付订单数',
  `order_total_amount` decimal(11,4) DEFAULT '0.0000' COMMENT '订单总额',
  `order_success_amount` decimal(11,4) DEFAULT '0.0000' COMMENT '订单实付总额',
  `recon_date` date DEFAULT NULL COMMENT '统计日期',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户统计表';

-- ----------------------------
-- Table structure for pay_member_risk_control_config
-- ----------------------------
DROP TABLE IF EXISTS `pay_member_risk_control_config`;
CREATE TABLE `pay_member_risk_control_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `min_money` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '单笔最小金额',
  `max_money` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '单笔最大金额',
  `unit_all_money` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '单位时间内交易总金额',
  `all_money` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '当天交易总金额',
  `start_time` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT '一天交易开始时间',
  `end_time` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT '一天交易结束时间',
  `unit_number` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '单位时间内交易的总笔数',
  `edit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `time_unit` char(1) NOT NULL DEFAULT 'i' COMMENT '限制的时间单位',
  `unit_interval` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '单位时间值',
  `domain` varchar(255) NOT NULL DEFAULT ' ' COMMENT '防封域名',
  `system_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 系统规则 1 用户规则',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='交易配置';

-- ----------------------------
-- Table structure for pay_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_order`;
CREATE TABLE `pay_order` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `balance_type` int(2) NOT NULL DEFAULT 10001 COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT 2 COMMENT '状态：几类账户（一类、二类）',
  `product_id` int(11) DEFAULT NULL COMMENT '支付渠道id',
  `product_name` varchar(128) DEFAULT NULL COMMENT '支付渠道中文名称',
  `channel_id` int(11) DEFAULT NULL COMMENT '通道id',
  `channel_code` varchar(64) DEFAULT NULL COMMENT '供应商通道英文编码',
  `channel_title` varchar(128) DEFAULT NULL COMMENT '供应商通道中文名称',
  `merchant_no` varchar(100) DEFAULT NULL COMMENT '支付渠道商家号',
  `sign_key` varchar(500) DEFAULT NULL COMMENT '支付渠道密钥',
  `order_id` varchar(128) NOT NULL COMMENT '系统订单号',
  `out_trade_id` varchar(50) NOT NULL COMMENT '商户订单号（下游）',
  `channel_order_id` varchar(255) DEFAULT NULL COMMENT '上游订单号',
  `notify_url` varchar(256) NOT NULL COMMENT '商家异步通知地址',
  `amount` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000',
  `fee` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000',
  `real_amount` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000',
  `cost` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '成本',
  `cost_rate` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '成本费率',
  `mobile` varchar(64) DEFAULT NULL COMMENT '手机号',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  `extends` varchar(1000) NOT NULL DEFAULT '' COMMENT '额外的参数',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '订单状态: 0-未支付 1-已支付未返回 2-已支付已返回 3-超时订单 4-other',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `pay_success_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单支付成功时间',
  `return_url` varchar(256) NOT NULL DEFAULT '' COMMENT '商家页面通知地址',
  `origin_url` varchar(512) DEFAULT NULL COMMENT '服务器来源地址',
  `notify_num` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '已补发次数',
  `rate_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '费率类型：按单笔收费0，按比例收费：1',
  `handle_time` tinyint(1) NOT NULL DEFAULT '0' COMMENT '到账时间 0-to 1-t1',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `order_product_id` (`product_id`) USING BTREE,
  KEY `order_channel_id` (`channel_id`) USING BTREE,
  KEY `order_order_id` (`order_id`) USING BTREE,
  KEY `order_out_trade_id` (`out_trade_id`) USING BTREE,
  KEY `order_channel_order_id` (`channel_order_id`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Table structure for pay_product
-- ----------------------------
DROP TABLE IF EXISTS `pay_product`;
CREATE TABLE `pay_product` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(128) NOT NULL COMMENT '通道名称',
  `code` varchar(64) NOT NULL COMMENT '通道代码',
  `balance_type` int(2) NOT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `channel` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '通道ID',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `polling` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '接口模式 0 单独 1 轮询',
  `display` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '用户端显示 1 显示 0 不显示',
  `weight` varchar(128) DEFAULT NULL COMMENT '平台默认通道权重',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付产品表';

-- ----------------------------
-- Table structure for pay_product_user
-- ----------------------------
DROP TABLE IF EXISTS `pay_product_user`;
CREATE TABLE `pay_product_user` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '商户通道ID',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `channel` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '通道ID',
  `polling` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '接口模式 0 单独 1 轮询',
  `weight` varchar(128) DEFAULT NULL COMMENT '平台默认通道权重',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付产品用户配置表';

-- ----------------------------
-- Table structure for pay_redo_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_redo_order`;
CREATE TABLE `pay_redo_order` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '操作管理员',
  `amount` decimal(25,4) NOT NULL COMMENT '操作金额',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1：增加 2：减少',
  `redo_date` date DEFAULT NULL COMMENT '冲正周期',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for pay_system_bank
-- ----------------------------
DROP TABLE IF EXISTS `pay_system_bank`;
CREATE TABLE `pay_system_bank` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `bank_code` varchar(100) DEFAULT NULL COMMENT '银行编码',
  `bank_name` varchar(300) DEFAULT NULL COMMENT '银行名称',
  `images` varchar(300) DEFAULT NULL COMMENT '图片',
  `balance_type` int(11) DEFAULT NULL COMMENT '币种',
  `country` char(128) DEFAULT NULL COMMENT '国家',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='银行配置表';

-- ----------------------------
-- Table structure for payment_api_order
-- ----------------------------
DROP TABLE IF EXISTS `payment_api_order`;
CREATE TABLE `payment_api_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '订单id',
  `out_trade_no` varchar(30) NOT NULL DEFAULT '' COMMENT '商户订单号',
  `balance_type` int(2) NOT NULL COMMENT '货币类型',
  `balance_symbol` varchar(256) NOT NULL DEFAULT '货币符号' COMMENT '₹ Rp等',
  `notify_url` varchar(255) DEFAULT NULL COMMENT '代付回调通知地址',
  `amount` decimal(25,4) NOT NULL DEFAULT '0.0000' COMMENT '提现金额',
  `bank_card_no` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  `bank_account` varchar(32) DEFAULT NULL COMMENT '户名',
  `bank_code` varchar(128) DEFAULT NULL COMMENT '银行编码',
  `ifsc` varchar(32) DEFAULT NULL COMMENT '印度支付必填(11位，第五位为0)',
  `mobile` varchar(256) DEFAULT NULL COMMENT '手机号',
  `email` varchar(256) DEFAULT NULL COMMENT '邮箱',
  `extends` varchar(1000) NOT NULL DEFAULT '' COMMENT '额外的参数',
  `df_id` int(11) NOT NULL DEFAULT '0' COMMENT '代付ID',
  `df_charge_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代付API扣除手续费方式，0：从到账金额里扣，1：从商户余额里扣',
  `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0：待审核 1：已提交后台审核 2：审核驳回',
  `reject_reason` varchar(255) NOT NULL DEFAULT '' COMMENT '驳回原因',
  `check_time` datetime DEFAULT NULL COMMENT '审核时间',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '0-未处理 1-处理中 2-已打款 3-已驳回 4-打款失败',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `df_api_order_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代付订单';

-- ----------------------------
-- Table structure for payment_channel
-- ----------------------------
DROP TABLE IF EXISTS `payment_channel`;
CREATE TABLE `payment_channel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `code` varchar(64) NOT NULL COMMENT '代付代码',
  `title` varchar(64) NOT NULL COMMENT '代付名称',
  `balance_type` int(2) NOT NULL COMMENT '账本类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：几类账户（一类、二类）',
  `merchant_no` varchar(100) DEFAULT NULL COMMENT '商户号',
  `sign_key` varchar(512) DEFAULT NULL COMMENT '签文密钥',
  `payment_gateway` varchar(256) NOT NULL DEFAULT ' ' COMMENT '请求代付的地址',
  `notify_url` varchar(256) NOT NULL DEFAULT ' ' COMMENT '服务器通知网址',
  `default` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认：1是，0否',
  `cost_rate_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '费率类型：0-按单笔收费0 1-按比例收费 2-单笔+比例',
  `cost_rate` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '比例收费值',
  `cost_fixed_rate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单笔收取费用',
  `public_key` varchar(1024) DEFAULT NULL COMMENT '加密的公钥',
  `private_key` varchar(2048) DEFAULT NULL COMMENT '加密的私钥',
  `platform_public_key` varchar(1024) DEFAULT NULL COMMENT '平台公钥',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `query_gateway` varchar(256) NOT NULL DEFAULT ' ' COMMENT '查询代付的地址',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代付通道表';

-- ----------------------------
-- Table structure for payment_order
-- ----------------------------
DROP TABLE IF EXISTS `payment_order`;
CREATE TABLE `payment_order` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '订单id',
  `out_trade_no` varchar(128) DEFAULT '' COMMENT '下游订单号',
  `channel_order_id` varchar(255) DEFAULT NULL COMMENT '上游订单号',
  `balance_type` int(2) NOT NULL COMMENT '货币类型',
  `balance_level` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态：几类账户（一类、二类）',
  `notify_url` varchar(255) DEFAULT NULL COMMENT '代付回调通知地址',
  `bank_card_no` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  `bank_account` varchar(32) DEFAULT NULL COMMENT '户名',
  `bank_code` varchar(128) DEFAULT NULL COMMENT '银行编码',
  `ifsc` varchar(32) DEFAULT NULL COMMENT '印度支付必填(11位，第五位为0)',
  `mobile` varchar(256) DEFAULT NULL COMMENT '手机号',
  `email` varchar(256) DEFAULT NULL COMMENT '邮箱',
  `extends` varchar(1000) NOT NULL DEFAULT '' COMMENT '额外的参数',
  `withdraw_amount` decimal(25,4) NOT NULL DEFAULT '0.0000',
  `withdraw_fee` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '手续费',
  `withdraw_real_amount` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '实际到账',
  `handle_time` tinyint(1) NOT NULL DEFAULT '0' COMMENT '到账时间 0-to 1-t1',
  `cost` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '成本',
  `cost_rate` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '成本费率',
  `rate_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '费率类型：按单笔收费0，按比例收费：1',
  `df_lock` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代付锁，防止重复提交',
  `df_code` varchar(64) NOT NULL DEFAULT '' COMMENT '代码控制器名称',
  `df_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '代付通道id',
  `df_name` varchar(64) NOT NULL DEFAULT '' COMMENT '代付名称',
  `df_charge_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代付API扣除手续费方式，0：从到账金额里扣，1：从商户余额里扣',
  `channel_mch_id` varchar(50) NOT NULL DEFAULT '' COMMENT '通道商户号',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `approve_time` datetime DEFAULT NULL COMMENT '审核通过时间',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '0-未处理 1-处理中 2-已打款 3-已驳回 4-打款失败',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `pay_api_id` int(11) NOT NULL DEFAULT '0',
  `df_api_id` int(11) DEFAULT '0' COMMENT '代付API申请ID',
  `auto_submit_try` int(10) NOT NULL DEFAULT '0' COMMENT '自动代付尝试提交次数',
  `is_auto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自动提交',
  `last_submit_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后提交时间',
  `auto_query_num` int(10) NOT NULL DEFAULT '0' COMMENT '自动查询次数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `df_code` (`df_code`) USING BTREE,
  KEY `df_id` (`df_id`) USING BTREE,
  KEY `order_id` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代付订单表';

-- ----------------------------
-- Table structure for payment_usdt_order
-- ----------------------------
DROP TABLE IF EXISTS `payment_usdt_order`;
CREATE TABLE `payment_usdt_order` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `amount` decimal(25,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '回U金额',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `usdt_address` varchar(256) DEFAULT NULL COMMENT 'usdt地址',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `state` tinyint(4) DEFAULT '1' COMMENT '订单状态: 0-未支付 1-处理中 2-已回U 3-已驳回',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='回u订单表';

-- ----------------------------
-- Table structure for t_isv_info
-- ----------------------------
DROP TABLE IF EXISTS `t_isv_info`;
CREATE TABLE `t_isv_info` (
  `isv_no` varchar(64) NOT NULL COMMENT '服务商号',
  `isv_name` varchar(64) NOT NULL COMMENT '服务商名称',
  `isv_short_name` varchar(32) NOT NULL COMMENT '服务商简称',
  `contact_name` varchar(32) DEFAULT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(32) DEFAULT NULL COMMENT '联系人手机号',
  `contact_email` varchar(32) DEFAULT NULL COMMENT '联系人邮箱',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '状态: 0-停用, 1-正常',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `created_uid` bigint(20) DEFAULT NULL COMMENT '创建者用户ID',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建者姓名',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`isv_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务商信息表';

-- ----------------------------
-- Table structure for t_mch_app
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_app`;
CREATE TABLE `t_mch_app` (
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `app_name` varchar(64) NOT NULL DEFAULT '' COMMENT '应用名称',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '应用状态: 0-停用, 1-正常',
  `app_secret` varchar(128) NOT NULL COMMENT '应用私钥',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `created_uid` bigint(20) DEFAULT NULL COMMENT '创建者用户ID',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建者姓名',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户应用表';

-- ----------------------------
-- Table structure for t_mch_division_receiver
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_division_receiver`;
CREATE TABLE `t_mch_division_receiver` (
  `receiver_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分账接收者ID',
  `receiver_alias` varchar(64) NOT NULL COMMENT '接收者账号别名',
  `receiver_group_id` bigint(20) DEFAULT NULL COMMENT '组ID（便于商户接口使用）',
  `receiver_group_name` varchar(64) DEFAULT NULL COMMENT '组名称',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口代码',
  `acc_type` tinyint(6) NOT NULL COMMENT '分账接收账号类型: 0-个人(对私) 1-商户(对公)',
  `acc_no` varchar(50) NOT NULL COMMENT '分账接收账号',
  `acc_name` varchar(30) NOT NULL DEFAULT '' COMMENT '分账接收账号名称',
  `relation_type` varchar(30) NOT NULL COMMENT '分账关系类型（参考微信）， 如： SERVICE_PROVIDER 服务商等',
  `relation_type_name` varchar(30) NOT NULL COMMENT '当选择自定义时，需要录入该字段。 否则为对应的名称',
  `division_profit` decimal(20,6) DEFAULT NULL COMMENT '分账比例',
  `state` tinyint(6) NOT NULL COMMENT '分账状态（本系统状态，并不调用上游关联关系）: 1-正常分账, 0-暂停分账',
  `channel_bind_result` text COMMENT '上游绑定返回信息，一般用作查询账号异常时的记录',
  `channel_ext_info` text COMMENT '渠道特殊信息',
  `bind_success_time` datetime DEFAULT NULL COMMENT '绑定成功时间',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`receiver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户分账接收者账号绑定关系表';

-- ----------------------------
-- Table structure for t_mch_division_receiver_group
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_division_receiver_group`;
CREATE TABLE `t_mch_division_receiver_group` (
  `receiver_group_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '组ID',
  `receiver_group_name` varchar(64) NOT NULL COMMENT '组名称',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `auto_division_flag` tinyint(6) NOT NULL DEFAULT '0' COMMENT '自动分账组（当订单分账模式为自动分账，改组将完成分账逻辑） 0-否 1-是',
  `created_uid` bigint(20) NOT NULL COMMENT '创建者用户ID',
  `created_by` varchar(64) NOT NULL COMMENT '创建者姓名',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`receiver_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分账账号组';

-- ----------------------------
-- Table structure for t_mch_info
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_info`;
CREATE TABLE `t_mch_info` (
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `mch_name` varchar(64) NOT NULL COMMENT '商户名称',
  `mch_short_name` varchar(32) NOT NULL COMMENT '商户简称',
  `type` tinyint(6) NOT NULL DEFAULT '1' COMMENT '类型: 1-普通商户, 2-特约商户(服务商模式)',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `contact_name` varchar(32) DEFAULT NULL COMMENT '联系人姓名',
  `contact_tel` varchar(32) DEFAULT NULL COMMENT '联系人手机号',
  `contact_email` varchar(32) DEFAULT NULL COMMENT '联系人邮箱',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '商户状态: 0-停用, 1-正常',
  `remark` varchar(128) DEFAULT NULL COMMENT '商户备注',
  `init_user_id` bigint(20) DEFAULT NULL COMMENT '初始用户ID（创建商户时，允许商户登录的用户）',
  `created_uid` bigint(20) DEFAULT NULL COMMENT '创建者用户ID',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建者姓名',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`mch_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户信息表';

-- ----------------------------
-- Table structure for t_mch_notify_record
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_notify_record`;
CREATE TABLE `t_mch_notify_record` (
  `notify_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商户通知记录ID',
  `order_id` varchar(64) NOT NULL COMMENT '订单ID',
  `order_type` tinyint(6) NOT NULL COMMENT '订单类型:1-支付,2-退款',
  `mch_order_no` varchar(64) NOT NULL COMMENT '商户订单号',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `notify_url` text NOT NULL COMMENT '通知地址',
  `res_result` text COMMENT '通知响应结果',
  `notify_count` int(11) NOT NULL DEFAULT '0' COMMENT '通知次数',
  `notify_count_limit` int(11) NOT NULL DEFAULT '6' COMMENT '最大通知次数, 默认6次',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '通知状态,1-通知中,2-通知成功,3-通知失败',
  `last_notify_time` datetime DEFAULT NULL COMMENT '最后一次通知时间',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`notify_id`),
  UNIQUE KEY `Uni_OrderId_Type` (`order_id`,`order_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户通知记录表';

-- ----------------------------
-- Table structure for t_mch_pay_passage
-- ----------------------------
DROP TABLE IF EXISTS `t_mch_pay_passage`;
CREATE TABLE `t_mch_pay_passage` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口',
  `way_code` varchar(20) NOT NULL COMMENT '支付方式',
  `rate` decimal(20,6) NOT NULL COMMENT '支付方式费率',
  `risk_config` varchar(4096) DEFAULT NULL COMMENT '风控数据',
  `state` tinyint(6) NOT NULL COMMENT '状态: 0-停用, 1-启用',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Uni_AppId_WayCode` (`app_id`,`if_code`,`way_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户支付通道表';

-- ----------------------------
-- Table structure for t_order_snapshot
-- ----------------------------
DROP TABLE IF EXISTS `t_order_snapshot`;
CREATE TABLE `t_order_snapshot` (
  `order_id` varchar(64) NOT NULL COMMENT '订单ID',
  `order_type` tinyint(6) NOT NULL COMMENT '订单类型: 1-支付, 2-退款',
  `mch_req_data` text COMMENT '下游请求数据',
  `mch_req_time` datetime DEFAULT NULL COMMENT '下游请求时间',
  `mch_resp_data` text COMMENT '向下游响应数据',
  `mch_resp_time` datetime DEFAULT NULL COMMENT '向下游响应时间',
  `channel_req_data` text COMMENT '向上游请求数据',
  `channel_req_time` datetime DEFAULT NULL COMMENT '向上游请求时间',
  `channel_resp_data` text COMMENT '上游响应数据',
  `channel_resp_time` datetime DEFAULT NULL COMMENT '上游响应时间',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`order_id`,`order_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单接口数据快照';

-- ----------------------------
-- Table structure for t_pay_interface_config
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_interface_config`;
CREATE TABLE `t_pay_interface_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `info_type` tinyint(6) NOT NULL COMMENT '账号类型:1-服务商 2-商户 3-商户应用',
  `info_id` varchar(64) NOT NULL COMMENT '服务商号/商户号/应用ID',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口代码',
  `if_params` varchar(4096) NOT NULL COMMENT '接口配置参数,json字符串',
  `if_rate` decimal(20,6) DEFAULT NULL COMMENT '支付接口费率',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '状态: 0-停用, 1-启用',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `created_uid` bigint(20) DEFAULT NULL COMMENT '创建者用户ID',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建者姓名',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_uid` bigint(20) DEFAULT NULL COMMENT '更新者用户ID',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新者姓名',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Uni_InfoType_InfoId_IfCode` (`info_type`,`info_id`,`if_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付接口配置参数表';

-- ----------------------------
-- Table structure for t_pay_interface_define
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_interface_define`;
CREATE TABLE `t_pay_interface_define` (
  `if_code` varchar(20) NOT NULL COMMENT '接口代码 全小写  wxpay alipay ',
  `if_name` varchar(20) NOT NULL COMMENT '接口名称',
  `is_mch_mode` tinyint(6) NOT NULL DEFAULT '1' COMMENT '是否支持普通商户模式: 0-不支持, 1-支持',
  `is_isv_mode` tinyint(6) NOT NULL DEFAULT '1' COMMENT '是否支持服务商子商户模式: 0-不支持, 1-支持',
  `config_page_type` tinyint(6) NOT NULL DEFAULT '1' COMMENT '支付参数配置页面类型:1-JSON渲染,2-自定义',
  `isv_params` varchar(4096) DEFAULT NULL COMMENT 'ISV接口配置定义描述,json字符串',
  `isvsub_mch_params` varchar(4096) DEFAULT NULL COMMENT '特约商户接口配置定义描述,json字符串',
  `normal_mch_params` varchar(4096) DEFAULT NULL COMMENT '普通商户接口配置定义描述,json字符串',
  `way_codes` varchar(64) NOT NULL COMMENT '支持的支付方式 ["wxpay_jsapi", "wxpay_bar"]',
  `icon` varchar(256) DEFAULT NULL COMMENT '页面展示：卡片-图标',
  `bg_color` varchar(20) DEFAULT NULL COMMENT '页面展示：卡片-背景色',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '状态: 0-停用, 1-启用',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`if_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付接口定义表';

-- ----------------------------
-- Records of t_pay_interface_define
-- ----------------------------
BEGIN;
INSERT INTO `t_pay_interface_define` VALUES ('alipay', '支付宝官方', 1, 1, 2, '[{\"name\":\"sandbox\",\"desc\":\"环境配置\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"1,0\",\"titles\":\"沙箱环境,生产环境\",\"verify\":\"required\"},{\"name\":\"pid\",\"desc\":\"合作伙伴身份（PID）\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"appId\",\"desc\":\"应用App ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"privateKey\", \"desc\":\"应用私钥\", \"type\": \"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"alipayPublicKey\", \"desc\":\"支付宝公钥(不使用证书时必填)\", \"type\": \"textarea\",\"star\":\"1\"},{\"name\":\"signType\",\"desc\":\"接口签名方式(推荐使用RSA2)\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"RSA,RSA2\",\"titles\":\"RSA,RSA2\",\"verify\":\"required\"},{\"name\":\"useCert\",\"desc\":\"公钥证书\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"1,0\",\"titles\":\"使用证书（请使用RSA2私钥）,不使用证书\"},{\"name\":\"appPublicCert\",\"desc\":\"应用公钥证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"},{\"name\":\"alipayPublicCert\",\"desc\":\"支付宝公钥证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"},{\"name\":\"alipayRootCert\",\"desc\":\"支付宝根证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"}]', '[{\"name\":\"appAuthToken\", \"desc\":\"子商户app_auth_token\", \"type\": \"text\",\"readonly\":\"readonly\"},{\"name\":\"refreshToken\", \"desc\":\"子商户刷新token\", \"type\": \"hidden\",\"readonly\":\"readonly\"},{\"name\":\"expireTimestamp\", \"desc\":\"authToken有效期（13位时间戳）\", \"type\": \"hidden\",\"readonly\":\"readonly\"}]', '[{\"name\":\"sandbox\",\"desc\":\"环境配置\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"1,0\",\"titles\":\"沙箱环境,生产环境\",\"verify\":\"required\"},{\"name\":\"appId\",\"desc\":\"应用App ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"privateKey\", \"desc\":\"应用私钥\", \"type\": \"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"alipayPublicKey\", \"desc\":\"支付宝公钥(不使用证书时必填)\", \"type\": \"textarea\",\"star\":\"1\"},{\"name\":\"signType\",\"desc\":\"接口签名方式(推荐使用RSA2)\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"RSA,RSA2\",\"titles\":\"RSA,RSA2\",\"verify\":\"required\"},{\"name\":\"useCert\",\"desc\":\"公钥证书\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"1,0\",\"titles\":\"使用证书（请使用RSA2私钥）,不使用证书\"},{\"name\":\"appPublicCert\",\"desc\":\"应用公钥证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"},{\"name\":\"alipayPublicCert\",\"desc\":\"支付宝公钥证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"},{\"name\":\"alipayRootCert\",\"desc\":\"支付宝根证书（.crt格式）\",\"type\":\"file\",\"verify\":\"\"}]', '[{\"wayCode\": \"ALI_JSAPI\"}, {\"wayCode\": \"ALI_WAP\"}, {\"wayCode\": \"', 'http://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/alipay.png', '#1779FF', 1, '支付宝官方通道', '2023-08-10 09:30:42.828329', '2023-08-10 09:30:42.828329');
INSERT INTO `t_pay_interface_define` VALUES ('plspay', '计全付', 1, 0, 1, NULL, NULL, '[{\"name\":\"signType\",\"desc\":\"签名方式\",\"type\":\"radio\",\"verify\":\"required\",\"values\":\"MD5,RSA2\",\"titles\":\"MD5,RSA2\"},{\"name\":\"merchantNo\",\"desc\":\"计全付商户号\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"appId\",\"desc\":\"应用ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"appSecret\",\"desc\":\"md5秘钥\",\"type\":\"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"rsa2AppPrivateKey\",\"desc\":\"RSA2: 应用私钥\",\"type\":\"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"rsa2PayPublicKey\",\"desc\":\"RSA2: 支付网关公钥\",\"type\":\"textarea\",\"verify\":\"required\",\"star\":\"1\"}]', '[{\"wayCode\": \"ALI_APP\"}, {\"wayCode\": \"ALI_BAR\"}, {\"wayCode\": \"AL', 'http://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/plspay.svg', '#0CACFF', 1, '计全付', '2023-08-10 09:30:42.830791', '2023-08-10 09:30:42.830791');
INSERT INTO `t_pay_interface_define` VALUES ('pppay', 'PayPal支付', 1, 0, 1, NULL, NULL, '[{\"name\":\"sandbox\",\"desc\":\"环境配置\",\"type\":\"radio\",\"verify\":\"required\",\"values\":\"1,0\",\"titles\":\"沙箱环境, 生产环境\"},{\"name\":\"clientId\",\"desc\":\"Client ID（客户端ID）\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"secret\",\"desc\":\"Secret（密钥）\",\"type\":\"text\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"refundWebhook\",\"desc\":\"退款 Webhook id\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"notifyWebhook\",\"desc\":\"支付 Webhook id\",\"type\":\"text\",\"verify\":\"required\"}]', '[{\"wayCode\": \"PP_PC\"}]', 'http://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/paypal.png', '#005ea6', 1, 'PayPal官方通道', '2023-08-10 09:30:42.830420', '2023-08-10 09:30:42.830420');
INSERT INTO `t_pay_interface_define` VALUES ('wxpay', '微信支付官方', 1, 1, 2, '[{\"name\":\"mchId\", \"desc\":\"微信支付商户号\", \"type\": \"text\",\"verify\":\"required\"},{\"name\":\"appId\",\"desc\":\"应用App ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"appSecret\",\"desc\":\"应用AppSecret\",\"type\":\"text\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"oauth2Url\", \"desc\":\"oauth2地址（置空将使用官方）\", \"type\": \"text\"},{\"name\":\"apiVersion\", \"desc\":\"微信支付API版本\", \"type\": \"radio\",\"values\":\"V2,V3\",\"titles\":\"V2,V3\",\"verify\":\"required\"},{\"name\":\"key\", \"desc\":\"APIv2密钥\", \"type\": \"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"apiV3Key\", \"desc\":\"APIv3密钥（V3接口必填）\", \"type\": \"textarea\",\"verify\":\"\",\"star\":\"1\"},{\"name\":\"serialNo\", \"desc\":\"序列号（V3接口必填）\", \"type\": \"textarea\",\"verify\":\"\",\"star\":\"1\"},{\"name\":\"cert\", \"desc\":\"API证书(apiclient_cert.p12)\", \"type\": \"file\",\"verify\":\"\"},{\"name\":\"apiClientCert\", \"desc\":\"证书文件(apiclient_cert.pem) \", \"type\": \"file\",\"verify\":\"\"},{\"name\":\"apiClientKey\", \"desc\":\"私钥文件(apiclient_key.pem)\", \"type\": \"file\",\"verify\":\"\"}]', '[{\"name\":\"subMchId\",\"desc\":\"子商户ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"subMchAppId\",\"desc\":\"子账户appID(线上支付必填)\",\"type\":\"text\",\"verify\":\"\"}]', '[{\"name\":\"mchId\", \"desc\":\"微信支付商户号\", \"type\": \"text\",\"verify\":\"required\"},{\"name\":\"appId\",\"desc\":\"应用App ID\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"appSecret\",\"desc\":\"应用AppSecret\",\"type\":\"text\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"oauth2Url\", \"desc\":\"oauth2地址（置空将使用官方）\", \"type\": \"text\"},{\"name\":\"apiVersion\", \"desc\":\"微信支付API版本\", \"type\": \"radio\",\"values\":\"V2,V3\",\"titles\":\"V2,V3\",\"verify\":\"required\"},{\"name\":\"key\", \"desc\":\"APIv2密钥\", \"type\": \"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"apiV3Key\", \"desc\":\"APIv3密钥（V3接口必填）\", \"type\": \"textarea\",\"verify\":\"\",\"star\":\"1\"},{\"name\":\"serialNo\", \"desc\":\"序列号（V3接口必填）\", \"type\": \"textarea\",\"verify\":\"\",\"star\":\"1\" },{\"name\":\"cert\", \"desc\":\"API证书(apiclient_cert.p12)\", \"type\": \"file\",\"verify\":\"\"},{\"name\":\"apiClientCert\", \"desc\":\"证书文件(apiclient_cert.pem) \", \"type\": \"file\",\"verify\":\"\"},{\"name\":\"apiClientKey\", \"desc\":\"私钥文件(apiclient_key.pem)\", \"type\": \"file\",\"verify\":\"\"}]', '[{\"wayCode\": \"WX_APP\"}, {\"wayCode\": \"WX_H5\"}, {\"wayCode\": \"WX_NA', 'http://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/wxpay.png', '#04BE02', 1, '微信官方通道', '2023-08-10 09:30:42.829170', '2023-08-10 09:30:42.829170');
INSERT INTO `t_pay_interface_define` VALUES ('ysfpay', '云闪付官方', 0, 1, 1, '[{\"name\":\"sandbox\",\"desc\":\"环境配置\",\"type\":\"radio\",\"verify\":\"\",\"values\":\"1,0\",\"titles\":\"沙箱环境,生产环境\",\"verify\":\"required\"},{\"name\":\"serProvId\",\"desc\":\"服务商开发ID[serProvId]\",\"type\":\"text\",\"verify\":\"required\"},{\"name\":\"isvPrivateCertFile\",\"desc\":\"服务商私钥文件（.pfx格式）\",\"type\":\"file\",\"verify\":\"required\"},{\"name\":\"isvPrivateCertPwd\",\"desc\":\"服务商私钥文件密码\",\"type\":\"text\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"ysfpayPublicKey\",\"desc\":\"云闪付开发公钥（证书管理页面可查询）\",\"type\":\"textarea\",\"verify\":\"required\",\"star\":\"1\"},{\"name\":\"acqOrgCode\",\"desc\":\"可用支付机构编号\",\"type\":\"text\",\"verify\":\"required\"}]', '[{\"name\":\"merId\",\"desc\":\"商户编号\",\"type\":\"text\",\"verify\":\"required\"}]', NULL, '[{\"wayCode\": \"YSF_BAR\"}, {\"wayCode\": \"ALI_JSAPI\"}, {\"wayCode\": \"', 'http://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/ysfpay.png', 'red', 1, '云闪付官方通道', '2023-08-10 09:30:42.829921', '2023-08-10 09:30:42.829921');
COMMIT;

-- ----------------------------
-- Table structure for t_pay_order
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_order`;
CREATE TABLE `t_pay_order` (
  `pay_order_id` varchar(30) NOT NULL COMMENT '支付订单号',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `mch_name` varchar(30) NOT NULL COMMENT '商户名称',
  `mch_type` tinyint(6) NOT NULL COMMENT '类型: 1-普通商户, 2-特约商户(服务商模式)',
  `mch_order_no` varchar(64) NOT NULL COMMENT '商户订单号',
  `if_code` varchar(20) DEFAULT NULL COMMENT '支付接口代码',
  `way_code` varchar(20) NOT NULL COMMENT '支付方式代码',
  `amount` bigint(20) NOT NULL COMMENT '支付金额,单位分',
  `mch_fee_rate` decimal(20,6) NOT NULL COMMENT '商户手续费费率快照',
  `mch_fee_amount` bigint(20) NOT NULL COMMENT '商户手续费,单位分',
  `currency` varchar(3) NOT NULL DEFAULT 'cny' COMMENT '三位货币代码,人民币:cny',
  `state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '支付状态: 0-订单生成, 1-支付中, 2-支付成功, 3-支付失败, 4-已撤销, 5-已退款, 6-订单关闭',
  `notify_state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '向下游回调状态, 0-未发送,  1-已发送',
  `client_ip` varchar(32) DEFAULT NULL COMMENT '客户端IP',
  `subject` varchar(64) NOT NULL COMMENT '商品标题',
  `body` varchar(256) NOT NULL COMMENT '商品描述信息',
  `channel_extra` varchar(512) DEFAULT NULL COMMENT '特定渠道发起额外参数',
  `channel_user` varchar(64) DEFAULT NULL COMMENT '渠道用户标识,如微信openId,支付宝账号',
  `channel_order_no` varchar(64) DEFAULT NULL COMMENT '渠道订单号',
  `refund_state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '退款状态: 0-未发生实际退款, 1-部分退款, 2-全额退款',
  `refund_times` int(11) NOT NULL DEFAULT '0' COMMENT '退款次数',
  `refund_amount` bigint(20) NOT NULL DEFAULT '0' COMMENT '退款总金额,单位分',
  `division_mode` tinyint(6) DEFAULT '0' COMMENT '订单分账模式：0-该笔订单不允许分账, 1-支付成功按配置自动完成分账, 2-商户手动分账(解冻商户金额)',
  `division_state` tinyint(6) DEFAULT '0' COMMENT '订单分账状态：0-未发生分账, 1-等待分账任务处理, 2-分账处理中, 3-分账任务已结束(不体现状态)',
  `division_last_time` datetime DEFAULT NULL COMMENT '最新分账时间',
  `err_code` varchar(128) DEFAULT NULL COMMENT '渠道支付错误码',
  `err_msg` varchar(256) DEFAULT NULL COMMENT '渠道支付错误描述',
  `ext_param` varchar(128) DEFAULT NULL COMMENT '商户扩展参数',
  `notify_url` varchar(128) NOT NULL DEFAULT '' COMMENT '异步通知地址',
  `return_url` varchar(128) DEFAULT '' COMMENT '页面跳转地址',
  `expired_time` datetime DEFAULT NULL COMMENT '订单失效时间',
  `success_time` datetime DEFAULT NULL COMMENT '订单支付成功时间',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`pay_order_id`),
  UNIQUE KEY `Uni_MchNo_MchOrderNo` (`mch_no`,`mch_order_no`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付订单表';

-- ----------------------------
-- Table structure for t_pay_order_division_record
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_order_division_record`;
CREATE TABLE `t_pay_order_division_record` (
  `record_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分账记录ID',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `mch_name` varchar(30) NOT NULL COMMENT '商户名称',
  `mch_type` tinyint(6) NOT NULL COMMENT '类型: 1-普通商户, 2-特约商户(服务商模式)',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口代码',
  `pay_order_id` varchar(30) NOT NULL COMMENT '系统支付订单号',
  `pay_order_channel_order_no` varchar(64) DEFAULT NULL COMMENT '支付订单渠道支付订单号',
  `pay_order_amount` bigint(20) NOT NULL COMMENT '订单金额,单位分',
  `pay_order_division_amount` bigint(20) NOT NULL COMMENT '订单实际分账金额, 单位：分（订单金额 - 商户手续费 - 已退款金额）',
  `batch_order_id` varchar(30) NOT NULL COMMENT '系统分账批次号',
  `channel_batch_order_id` varchar(64) DEFAULT NULL COMMENT '上游分账批次号',
  `state` tinyint(6) NOT NULL COMMENT '状态: 0-待分账 1-分账成功（明确成功）, 2-分账失败（明确失败）, 3-分账已受理（上游受理）',
  `channel_resp_result` text COMMENT '上游返回数据包',
  `receiver_id` bigint(20) NOT NULL COMMENT '账号快照》 分账接收者ID',
  `receiver_group_id` bigint(20) DEFAULT NULL COMMENT '账号快照》 组ID（便于商户接口使用）',
  `receiver_alias` varchar(64) DEFAULT NULL COMMENT '接收者账号别名',
  `acc_type` tinyint(6) NOT NULL COMMENT '账号快照》 分账接收账号类型: 0-个人 1-商户',
  `acc_no` varchar(50) NOT NULL COMMENT '账号快照》 分账接收账号',
  `acc_name` varchar(30) NOT NULL DEFAULT '' COMMENT '账号快照》 分账接收账号名称',
  `relation_type` varchar(30) NOT NULL COMMENT '账号快照》 分账关系类型（参考微信）， 如： SERVICE_PROVIDER 服务商等',
  `relation_type_name` varchar(30) NOT NULL COMMENT '账号快照》 当选择自定义时，需要录入该字段。 否则为对应的名称',
  `division_profit` decimal(20,6) NOT NULL COMMENT '账号快照》 配置的实际分账比例',
  `cal_division_amount` bigint(20) NOT NULL COMMENT '计算该接收方的分账金额,单位分',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分账记录表';

-- ----------------------------
-- Table structure for t_pay_way
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_way`;
CREATE TABLE `t_pay_way` (
  `way_code` varchar(20) NOT NULL COMMENT '支付方式代码  例如： wxpay_jsapi',
  `way_name` varchar(20) NOT NULL COMMENT '支付方式名称',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`way_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付方式表';

-- ----------------------------
-- Records of t_pay_way
-- ----------------------------
BEGIN;
INSERT INTO `t_pay_way` VALUES ('ALI_APP', '支付宝APP', '2023-08-10 09:30:42.819912', '2023-08-10 09:30:42.819912');
INSERT INTO `t_pay_way` VALUES ('ALI_BAR', '支付宝条码', '2023-08-10 09:30:42.815414', '2023-08-10 09:30:42.815414');
INSERT INTO `t_pay_way` VALUES ('ALI_JSAPI', '支付宝生活号', '2023-08-10 09:30:42.819782', '2023-08-10 09:30:42.819782');
INSERT INTO `t_pay_way` VALUES ('ALI_LITE', '支付宝小程序', '2023-08-10 09:30:42.820346', '2023-08-10 09:30:42.820346');
INSERT INTO `t_pay_way` VALUES ('ALI_PC', '支付宝PC网站', '2023-08-10 09:30:42.820276', '2023-08-10 09:30:42.820276');
INSERT INTO `t_pay_way` VALUES ('ALI_QR', '支付宝二维码', '2023-08-10 09:30:42.820312', '2023-08-10 09:30:42.820312');
INSERT INTO `t_pay_way` VALUES ('ALI_WAP', '支付宝WAP', '2023-08-10 09:30:42.820203', '2023-08-10 09:30:42.820203');
INSERT INTO `t_pay_way` VALUES ('PP_PC', 'PayPal支付', '2023-08-10 09:30:42.820652', '2023-08-10 09:30:42.820652');
INSERT INTO `t_pay_way` VALUES ('UP_APP', '银联App支付', '2023-08-10 09:30:42.820685', '2023-08-10 09:30:42.820685');
INSERT INTO `t_pay_way` VALUES ('UP_B2B', '银联企业网银支付', '2023-08-10 09:30:42.820828', '2023-08-10 09:30:42.820828');
INSERT INTO `t_pay_way` VALUES ('UP_BAR', '银联二维码(被扫)', '2023-08-10 09:30:42.820794', '2023-08-10 09:30:42.820794');
INSERT INTO `t_pay_way` VALUES ('UP_JSAPI', '银联Js支付', '2023-08-10 09:30:42.820904', '2023-08-10 09:30:42.820904');
INSERT INTO `t_pay_way` VALUES ('UP_PC', '银联网关支付', '2023-08-10 09:30:42.820863', '2023-08-10 09:30:42.820863');
INSERT INTO `t_pay_way` VALUES ('UP_QR', '银联二维码(主扫)', '2023-08-10 09:30:42.820754', '2023-08-10 09:30:42.820754');
INSERT INTO `t_pay_way` VALUES ('UP_WAP', '银联手机网站支付', '2023-08-10 09:30:42.820719', '2023-08-10 09:30:42.820719');
INSERT INTO `t_pay_way` VALUES ('WX_APP', '微信APP', '2023-08-10 09:30:42.820448', '2023-08-10 09:30:42.820448');
INSERT INTO `t_pay_way` VALUES ('WX_BAR', '微信条码', '2023-08-10 09:30:42.820380', '2023-08-10 09:30:42.820380');
INSERT INTO `t_pay_way` VALUES ('WX_H5', '微信H5', '2023-08-10 09:30:42.820483', '2023-08-10 09:30:42.820483');
INSERT INTO `t_pay_way` VALUES ('WX_JSAPI', '微信公众号', '2023-08-10 09:30:42.820414', '2023-08-10 09:30:42.820414');
INSERT INTO `t_pay_way` VALUES ('WX_LITE', '微信小程序', '2023-08-10 09:30:42.820551', '2023-08-10 09:30:42.820551');
INSERT INTO `t_pay_way` VALUES ('WX_NATIVE', '微信扫码', '2023-08-10 09:30:42.820517', '2023-08-10 09:30:42.820517');
INSERT INTO `t_pay_way` VALUES ('YSF_BAR', '云闪付条码', '2023-08-10 09:30:42.820584', '2023-08-10 09:30:42.820584');
INSERT INTO `t_pay_way` VALUES ('YSF_JSAPI', '云闪付jsapi', '2023-08-10 09:30:42.820619', '2023-08-10 09:30:42.820619');
COMMIT;

-- ----------------------------
-- Table structure for t_refund_order
-- ----------------------------
DROP TABLE IF EXISTS `t_refund_order`;
CREATE TABLE `t_refund_order` (
  `refund_order_id` varchar(30) NOT NULL COMMENT '退款订单号（支付系统生成订单号）',
  `pay_order_id` varchar(30) NOT NULL COMMENT '支付订单号（与t_pay_order对应）',
  `channel_pay_order_no` varchar(64) DEFAULT NULL COMMENT '渠道支付单号（与t_pay_order channel_order_no对应）',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `mch_name` varchar(30) NOT NULL COMMENT '商户名称',
  `mch_type` tinyint(6) NOT NULL COMMENT '类型: 1-普通商户, 2-特约商户(服务商模式)',
  `mch_refund_no` varchar(64) NOT NULL COMMENT '商户退款单号（商户系统的订单号）',
  `way_code` varchar(20) NOT NULL COMMENT '支付方式代码',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口代码',
  `pay_amount` bigint(20) NOT NULL COMMENT '支付金额,单位分',
  `refund_amount` bigint(20) NOT NULL COMMENT '退款金额,单位分',
  `currency` varchar(3) NOT NULL DEFAULT 'cny' COMMENT '三位货币代码,人民币:cny',
  `state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '退款状态:0-订单生成,1-退款中,2-退款成功,3-退款失败,4-退款任务关闭',
  `client_ip` varchar(32) DEFAULT NULL COMMENT '客户端IP',
  `refund_reason` varchar(256) NOT NULL COMMENT '退款原因',
  `channel_order_no` varchar(32) DEFAULT NULL COMMENT '渠道订单号',
  `err_code` varchar(128) DEFAULT NULL COMMENT '渠道错误码',
  `err_msg` varchar(2048) DEFAULT NULL COMMENT '渠道错误描述',
  `channel_extra` varchar(512) DEFAULT NULL COMMENT '特定渠道发起时额外参数',
  `notify_url` varchar(128) DEFAULT NULL COMMENT '通知地址',
  `ext_param` varchar(64) DEFAULT NULL COMMENT '扩展参数',
  `success_time` datetime DEFAULT NULL COMMENT '订单退款成功时间',
  `expired_time` datetime DEFAULT NULL COMMENT '退款失效时间（失效后系统更改为退款任务关闭状态）',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`refund_order_id`),
  UNIQUE KEY `Uni_MchNo_MchRefundNo` (`mch_no`,`mch_refund_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='退款订单表';

-- ----------------------------
-- Table structure for t_sys_config
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_config`;
CREATE TABLE `t_sys_config` (
  `config_key` varchar(50) NOT NULL COMMENT '配置KEY',
  `config_name` varchar(50) NOT NULL COMMENT '配置名称',
  `config_desc` varchar(200) NOT NULL COMMENT '描述信息',
  `group_key` varchar(50) NOT NULL COMMENT '分组key',
  `group_name` varchar(50) NOT NULL COMMENT '分组名称',
  `config_val` text NOT NULL COMMENT '配置内容项',
  `type` varchar(20) NOT NULL DEFAULT 'text' COMMENT '类型: text-输入框, textarea-多行文本, uploadImg-上传图片, switch-开关',
  `sort_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`config_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统配置表';

-- ----------------------------
-- Records of t_sys_config
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_config` VALUES ('mchSiteUrl', '商户平台网址(不包含结尾/)', '商户平台网址(不包含结尾/)', 'applicationConfig', '系统应用配置', 'http://127.0.0.1:9218', 'text', 0, '2021-05-18 14:46:10.000000');
INSERT INTO `t_sys_config` VALUES ('mgrSiteUrl', '运营平台网址(不包含结尾/)', '运营平台网址(不包含结尾/)', 'applicationConfig', '系统应用配置', 'http://127.0.0.1:9217', 'text', 0, '2021-05-18 14:46:10.000000');
INSERT INTO `t_sys_config` VALUES ('ossPublicSiteUrl', '公共oss访问地址(不包含结尾/)', '公共oss访问地址(不包含结尾/)', 'applicationConfig', '系统应用配置', 'http://127.0.0.1:9217/api/anon/localOssFiles', 'text', 0, '2021-05-18 14:46:10.000000');
INSERT INTO `t_sys_config` VALUES ('paySiteUrl', '支付网关地址(不包含结尾/)', '支付网关地址(不包含结尾/)', 'applicationConfig', '系统应用配置', 'http://127.0.0.1:9216', 'text', 0, '2021-05-18 14:46:10.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_entitlement
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_entitlement`;
CREATE TABLE `t_sys_entitlement` (
  `ent_id` varchar(64) NOT NULL COMMENT '权限ID[ENT_功能模块_子模块_操作], eg: ENT_ROLE_LIST_ADD',
  `ent_name` varchar(32) NOT NULL COMMENT '权限名称',
  `menu_icon` varchar(32) DEFAULT NULL COMMENT '菜单图标',
  `menu_uri` varchar(128) DEFAULT NULL COMMENT '菜单uri/路由地址',
  `component_name` varchar(32) DEFAULT NULL COMMENT '组件Name（前后端分离使用）',
  `ent_type` char(2) NOT NULL COMMENT '权限类型 ML-左侧显示菜单, MO-其他菜单, PB-页面/按钮',
  `quick_jump` tinyint(6) NOT NULL DEFAULT '0' COMMENT '快速开始菜单 0-否, 1-是',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '状态 0-停用, 1-启用',
  `pid` varchar(32) NOT NULL COMMENT '父ID',
  `ent_sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序字段, 规则：正序',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`ent_id`,`sys_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统权限表';

-- ----------------------------
-- Records of t_sys_entitlement
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_entitlement` VALUES ('ENT_COMMONS', '系统通用菜单', 'no-icon', '', 'RouteView', 'MO', 0, 1, 'ROOT', -1, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_COMMONS', '系统通用菜单', 'no-icon', '', 'RouteView', 'MO', 0, 1, 'ROOT', -1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_MAIN', '主页', 'home', '/main', 'MainPage', 'ML', 0, 1, 'ROOT', 1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_MAIN_NUMBER_COUNT', '主页数量总统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_MAIN_PAY_AMOUNT_WEEK', '主页周支付统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_MAIN_PAY_COUNT', '主页交易统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_MAIN_PAY_TYPE_COUNT', '主页交易方式统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_USERINFO', '个人中心', 'no-icon', '/current/userinfo', 'CurrentUserInfo', 'MO', 0, 1, 'ENT_COMMONS', -1, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_C_USERINFO', '个人中心', 'no-icon', '/current/userinfo', 'CurrentUserInfo', 'MO', 0, 1, 'ENT_COMMONS', -1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_GOOGLE', '绑定谷歌验证', 'transaction', '/notify', 'GoogleSettingPage', 'ML', 0, 1, 'ENT_SYSTEM', 50, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:21:03.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV', '服务商管理', 'block', '', 'RouteView', 'ML', 0, 1, 'ROOT', 40, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_INFO', '服务商列表', 'profile', '/isv', 'IsvListPage', 'ML', 0, 1, 'ENT_ISV', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_INFO_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_INFO_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_INFO_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_INFO_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_LIST', '页面：服务商列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_PAY_CONFIG_ADD', '服务商支付参数配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_PAY_CONFIG_LIST', '服务商支付参数配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ISV_PAY_CONFIG_VIEW', '服务商支付参数配置详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_LOG_LIST', '页面：系统日志列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH', '商户管理', 'shop', '', 'RouteView', 'ML', 0, 1, 'ROOT', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP', '应用列表', 'appstore', '/apps', 'MchAppPage', 'ML', 0, 1, 'ENT_MCH', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_CONFIG', '应用配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_LIST', '页面：应用列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_APP_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_INFO', '商户列表', 'profile', '/mch', 'MchListPage', 'ML', 0, 1, 'ENT_MCH', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_INFO_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_INFO_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_INFO_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_INFO_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_LIST', '页面：商户列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN', '首页', 'home', '/main', 'MainPage', 'ML', 0, 1, 'ROOT', 100010, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN_NUMBER_COUNT', '主页数量总统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN_PAY_AMOUNT_WEEK', '主页周支付统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN_PAY_COUNT', '主页交易统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN_PAY_TYPE_COUNT', '主页交易方式统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_MAIN_USER_INFO', '主页用户信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:27:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_NOTIFY', '资金流水', 'notification', '/balance_log', 'BalanceLogListPage', 'ML', 0, 1, 'ENT_PAYMENT', 40, 'MCH', '2023-08-11 16:10:06.000000', '2023-08-11 16:10:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_NOTIFY', '商户通知', 'notification', '/notify', 'MchNotifyListPage', 'ML', 0, 1, 'ENT_ORDER', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_NOTIFY_RESEND', '按钮：重发通知', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_NOTIFY_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_CONFIG_ADD', '应用支付参数配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_CONFIG_LIST', '应用支付参数配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_CONFIG_VIEW', '应用支付参数配置详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_PASSAGE_ADD', '应用支付通道配置保存', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_PASSAGE_CONFIG', '应用支付通道配置入口', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_MCH_PAY_PASSAGE_LIST', '应用支付通道配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_NOTIFY_LIST', '页面：商户通知列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ORDER', '订单管理', 'transaction', '', 'RouteView', 'ML', 0, 1, 'ROOT', 50, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_ORDER_LIST', '页面：订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PASSWORD', '修改登录密码', 'exception', '/password', 'PasswordSettingPage', 'ML', 0, 1, 'ENT_SYSTEM', 20, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:21:03.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY', '交易管理', 'transaction', '', 'RouteView', 'ML', 0, 1, 'ROOT', 100020, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 15:59:33.715844');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAYMENT', '结算对账', 'property-safety', '', 'RouteView', 'ML', 0, 1, 'ROOT', 100030, 'MCH', '2023-08-11 16:10:06.000000', '2023-08-11 16:38:28.314113');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_MEMBER', '商户信息', 'account-book', '/member', 'MemberInfoPage', 'ML', 0, 1, 'ENT_SYSTEM', 10, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:21:03.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER', '申请回U', 'account-book', '/usdt/apply', 'UsdtApplyPage', 'ML', 0, 1, 'ENT_PAYMENT', 10, 'MCH', '2023-08-11 16:10:06.000000', '2023-08-11 16:10:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER', '支付订单', 'account-book', '/pay', 'PayOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER_ALL', '所有订单', 'property-safety', '/order/all', 'PayOrderAllListPage', 'ML', 0, 1, 'ENT_PAY', 20, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 16:01:02.104151');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER_REFUND', '按钮：订单退款', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER_SEARCH_PAY_WAY', '筛选项：支付方式', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER_SUCCESS', '成功订单', 'account-book', '/order/success', 'PayOrderSuccessListPage', 'ML', 0, 1, 'ENT_PAY', 10, 'MCH', '2023-08-11 15:27:06.000000', '2023-08-11 16:00:55.555196');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PAY_PASSWORD', '修改支付密码', 'notification', '/pay/password', 'PayPasswordSettingPage', 'ML', 0, 1, 'ENT_SYSTEM', 30, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:21:03.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC', '支付配置', 'file-done', '', 'RouteView', 'ML', 0, 1, 'ROOT', 60, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE', '支付接口', 'interaction', '/ifdefines', 'IfDefinePage', 'ML', 0, 1, 'ENT_PC', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_EDIT', '按钮：修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_LIST', '页面：支付接口定义列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_IF_DEFINE_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY', '支付方式', 'appstore', '/payways', 'PayWayPage', 'ML', 0, 1, 'ENT_PC', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_EDIT', '按钮：修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_LIST', '页面：支付方式列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_PC_WAY_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_REFUND_LIST', '页面：退款订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_REFUND_ORDER', '回U记录', 'exception', '/usdt/order', 'UsdtOrderListPage', 'ML', 0, 1, 'ENT_PAYMENT', 20, 'MCH', '2023-08-11 16:10:06.000000', '2023-08-11 16:10:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_REFUND_ORDER', '退款订单', 'exception', '/refund', 'RefundOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_REFUND_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SIGN_KEY', '设置支付密钥', 'property-safety', '/pay/google', 'SignKeySettingPage', 'ML', 0, 1, 'ENT_SYSTEM', 40, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:21:03.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYSTEM', '系统设置', 'setting', '', 'RouteView', 'ML', 0, 1, 'ROOT', 100040, 'MCH', '2023-08-11 16:21:03.000000', '2023-08-11 16:38:24.662401');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_CONFIG', '系统管理', 'setting', '', 'RouteView', 'ML', 0, 1, 'ROOT', 200, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_CONFIG_EDIT', '按钮： 修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_CONFIG_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_CONFIG_INFO', '系统配置', 'setting', '/config', 'SysConfigPage', 'ML', 0, 1, 'ENT_SYS_CONFIG', 15, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_LOG', '系统日志', 'file-text', '/log', 'SysLogPage', 'ML', 0, 1, 'ENT_SYS_CONFIG', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_LOG_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_SYS_LOG_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_TRANSFER_ORDER', '结算记录', 'property-safety', '/payment', 'PaymentOrderListPage', 'ML', 0, 1, 'ENT_PAYMENT', 30, 'MCH', '2023-08-11 16:10:06.000000', '2023-08-11 16:10:06.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_TRANSFER_ORDER', '转账订单', 'property-safety', '/transfer', 'TransferOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 25, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_TRANSFER_ORDER_LIST', '页面：转账订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_TRANSFER_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR', '用户角色管理', 'team', '', 'RouteView', 'ML', 0, 1, 'ENT_SYS_CONFIG', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE', '角色管理', 'user', '/roles', 'RolePage', 'ML', 0, 1, 'ENT_UR', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_ADD', '按钮：添加角色', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_DEL', '按钮： 删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_DIST', '按钮： 分配权限', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_EDIT', '按钮： 修改基本信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_ENT', '权限管理', 'apartment', '/ents', 'EntPage', 'ML', 0, 1, 'ENT_UR', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_ENT_EDIT', '按钮： 权限变更', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE_ENT', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_ENT_LIST', '页面： 权限列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE_ENT', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_LIST', '页面：角色列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_ROLE_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER', '操作员管理', 'contacts', '/users', 'SysUserPage', 'ML', 0, 1, 'ENT_UR', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_ADD', '按钮：添加操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_DELETE', '按钮： 删除操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_EDIT', '按钮： 修改基本信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_LIST', '页面：操作员列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_SEARCH', '按钮：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_UPD_ROLE', '按钮： 角色分配', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement` VALUES ('ENT_UR_USER_VIEW', '按钮： 详情', '', 'no-icon', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_entitlement_bak
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_entitlement_bak`;
CREATE TABLE `t_sys_entitlement_bak` (
  `ent_id` varchar(64) NOT NULL COMMENT '权限ID[ENT_功能模块_子模块_操作], eg: ENT_ROLE_LIST_ADD',
  `ent_name` varchar(32) NOT NULL COMMENT '权限名称',
  `menu_icon` varchar(32) DEFAULT NULL COMMENT '菜单图标',
  `menu_uri` varchar(128) DEFAULT NULL COMMENT '菜单uri/路由地址',
  `component_name` varchar(32) DEFAULT NULL COMMENT '组件Name（前后端分离使用）',
  `ent_type` char(2) NOT NULL COMMENT '权限类型 ML-左侧显示菜单, MO-其他菜单, PB-页面/按钮',
  `quick_jump` tinyint(6) NOT NULL DEFAULT '0' COMMENT '快速开始菜单 0-否, 1-是',
  `state` tinyint(6) NOT NULL DEFAULT '1' COMMENT '状态 0-停用, 1-启用',
  `pid` varchar(32) NOT NULL COMMENT '父ID',
  `ent_sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序字段, 规则：正序',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`ent_id`,`sys_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统权限备份表';

-- ----------------------------
-- Records of t_sys_entitlement_bak
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_COMMONS', '系统通用菜单', 'no-icon', '', 'RouteView', 'MO', 0, 1, 'ROOT', -1, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_COMMONS', '系统通用菜单', 'no-icon', '', 'RouteView', 'MO', 0, 1, 'ROOT', -1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_MAIN', '主页', 'home', '/main', 'MainPage', 'ML', 0, 1, 'ROOT', 1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_MAIN_NUMBER_COUNT', '主页数量总统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_MAIN_PAY_AMOUNT_WEEK', '主页周支付统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_MAIN_PAY_COUNT', '主页交易统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_MAIN_PAY_TYPE_COUNT', '主页交易方式统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_C_MAIN', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_USERINFO', '个人中心', 'no-icon', '/current/userinfo', 'CurrentUserInfo', 'MO', 0, 1, 'ENT_COMMONS', -1, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_C_USERINFO', '个人中心', 'no-icon', '/current/userinfo', 'CurrentUserInfo', 'MO', 0, 1, 'ENT_COMMONS', -1, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION', '分账管理', 'apartment', '', 'RouteView', 'ML', 0, 1, 'ROOT', 30, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER', '收款账号管理', 'trademark', '/divisionReceiver', 'DivisionReceiverPage', 'ML', 0, 1, 'ENT_DIVISION', 20, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_ADD', '按钮：新增收款账号', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_DELETE', '按钮：删除收款账号', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_EDIT', '按钮：修改账号信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP', '账号组管理', 'team', '/divisionReceiverGroup', 'DivisionReceiverGroupPage', 'ML', 0, 1, 'ENT_DIVISION', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER_GROUP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP_DELETE', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER_GROUP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP_EDIT', '按钮：修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER_GROUP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP_LIST', '页面：数据列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER_GROUP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_GROUP_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER_GROUP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_LIST', '页面：数据列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECEIVER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECEIVER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECORD', '分账记录', 'unordered-list', '/divisionRecord', 'DivisionRecordPage', 'ML', 0, 1, 'ENT_DIVISION', 30, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECORD_LIST', '页面：数据列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECORD', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECORD_RESEND', '按钮：重试', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECORD', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_DIVISION_RECORD_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_DIVISION_RECORD', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV', '服务商管理', 'block', '', 'RouteView', 'ML', 0, 1, 'ROOT', 40, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_INFO', '服务商列表', 'profile', '/isv', 'IsvListPage', 'ML', 0, 1, 'ENT_ISV', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_INFO_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_INFO_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_INFO_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_INFO_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_LIST', '页面：服务商列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_PAY_CONFIG_ADD', '服务商支付参数配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_PAY_CONFIG_LIST', '服务商支付参数配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ISV_PAY_CONFIG_VIEW', '服务商支付参数配置详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_ISV_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_LOG_LIST', '页面：系统日志列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH', '商户管理', 'shop', '', 'RouteView', 'ML', 0, 1, 'ROOT', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP', '应用管理', 'appstore', '/apps', 'MchAppPage', 'ML', 0, 1, 'ENT_MCH_CENTER', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP', '应用列表', 'appstore', '/apps', 'MchAppPage', 'ML', 0, 1, 'ENT_MCH', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_CONFIG', '应用配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_LIST', '页面：应用列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_LIST', '页面：应用列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_APP_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_CENTER', '商户中心', 'team', '', 'RouteView', 'ML', 0, 1, 'ROOT', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_INFO', '商户列表', 'profile', '/mch', 'MchListPage', 'ML', 0, 1, 'ENT_MCH', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_INFO_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_INFO_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_INFO_EDIT', '按钮：编辑', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_INFO_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_LIST', '页面：商户列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN', '主页', 'home', '/main', 'MainPage', 'ML', 0, 1, 'ROOT', 1, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN_NUMBER_COUNT', '主页数量总统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN_PAY_AMOUNT_WEEK', '主页周支付统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN_PAY_COUNT', '主页交易统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN_PAY_TYPE_COUNT', '主页交易方式统计', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_MAIN_USER_INFO', '主页用户信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_MAIN', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_NOTIFY', '商户通知', 'notification', '/notify', 'MchNotifyListPage', 'ML', 0, 1, 'ENT_ORDER', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_NOTIFY_RESEND', '按钮：重发通知', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_NOTIFY_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_ADD', '应用支付参数配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_ADD', '应用支付参数配置', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_LIST', '应用支付参数配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_LIST', '应用支付参数配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_VIEW', '应用支付参数配置详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_CONFIG_VIEW', '应用支付参数配置详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_CONFIG_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_ADD', '应用支付通道配置保存', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_ADD', '应用支付通道配置保存', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_CONFIG', '应用支付通道配置入口', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_CONFIG', '应用支付通道配置入口', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_PASSAGE_LIST', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_LIST', '应用支付通道配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_PASSAGE_LIST', '应用支付通道配置列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_APP', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_TEST', '支付测试', 'transaction', '/paytest', 'PayTestPage', 'ML', 0, 1, 'ENT_MCH_CENTER', 20, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_TEST_DO', '按钮：支付测试', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_TEST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_PAY_TEST_PAYWAY_LIST', '页面：获取全部支付方式', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_PAY_TEST', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_TRANSFER', '转账', 'property-safety', '/doTransfer', 'MchTransferPage', 'ML', 0, 1, 'ENT_MCH_CENTER', 30, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_TRANSFER_CHANNEL_USER', '按钮：获取渠道用户', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_TRANSFER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_TRANSFER_DO', '按钮：发起转账', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_TRANSFER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_MCH_TRANSFER_IF_CODE_LIST', '页面：获取全部代付通道', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_TRANSFER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_NOTIFY_LIST', '页面：商户通知列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_MCH_NOTIFY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ORDER', '订单中心', 'transaction', '', 'RouteView', 'ML', 0, 1, 'ROOT', 20, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ORDER', '订单管理', 'transaction', '', 'RouteView', 'ML', 0, 1, 'ROOT', 50, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ORDER_LIST', '页面：订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_ORDER_LIST', '页面：订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER', '订单管理', 'account-book', '/pay', 'PayOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER', '支付订单', 'account-book', '/pay', 'PayOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_REFUND', '按钮：订单退款', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_REFUND', '按钮：订单退款', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_SEARCH_PAY_WAY', '筛选项：支付方式', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_SEARCH_PAY_WAY', '筛选项：支付方式', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PAY_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PAY_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC', '支付配置', 'file-done', '', 'RouteView', 'ML', 0, 1, 'ROOT', 60, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE', '支付接口', 'interaction', '/ifdefines', 'IfDefinePage', 'ML', 0, 1, 'ENT_PC', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_EDIT', '按钮：修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_LIST', '页面：支付接口定义列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_IF_DEFINE_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_IF_DEFINE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY', '支付方式', 'appstore', '/payways', 'PayWayPage', 'ML', 0, 1, 'ENT_PC', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_ADD', '按钮：新增', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_EDIT', '按钮：修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_LIST', '页面：支付方式列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_PC_WAY_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_PC_WAY', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_LIST', '页面：退款订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_LIST', '页面：退款订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_ORDER', '退款记录', 'exception', '/refund', 'RefundOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 20, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_ORDER', '退款订单', 'exception', '/refund', 'RefundOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_REFUND_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_REFUND_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_CONFIG', '系统管理', 'setting', '', 'RouteView', 'ML', 0, 1, 'ROOT', 200, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_CONFIG', '系统管理', 'setting', '', 'RouteView', 'ML', 0, 1, 'ROOT', 200, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_CONFIG_EDIT', '按钮： 修改', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_CONFIG_INFO', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_CONFIG_INFO', '系统配置', 'setting', '/config', 'SysConfigPage', 'ML', 0, 1, 'ENT_SYS_CONFIG', 15, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_LOG', '系统日志', 'file-text', '/log', 'SysLogPage', 'ML', 0, 1, 'ENT_SYS_CONFIG', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_LOG_DEL', '按钮：删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_SYS_LOG_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_SYS_LOG', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER', '转账订单', 'property-safety', '/transfer', 'TransferOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 30, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER', '转账订单', 'property-safety', '/transfer', 'TransferOrderListPage', 'ML', 0, 1, 'ENT_ORDER', 25, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER_LIST', '页面：转账订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER_LIST', '页面：转账订单列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_TRANSFER_ORDER_VIEW', '按钮：详情', 'no-icon', '', '', 'PB', 0, 1, 'ENT_TRANSFER_ORDER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR', '用户角色管理', 'team', '', 'RouteView', 'ML', 0, 1, 'ENT_SYS_CONFIG', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR', '用户角色管理', 'team', '', 'RouteView', 'ML', 0, 1, 'ENT_SYS_CONFIG', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE', '角色管理', 'user', '/roles', 'RolePage', 'ML', 0, 1, 'ENT_UR', 20, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE', '角色管理', 'user', '/roles', 'RolePage', 'ML', 0, 1, 'ENT_UR', 20, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_ADD', '按钮：添加角色', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_ADD', '按钮：添加角色', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_DEL', '按钮： 删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_DEL', '按钮： 删除', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_DIST', '按钮： 分配权限', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_DIST', '按钮： 分配权限', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_EDIT', '按钮： 修改名称', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_EDIT', '按钮： 修改基本信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_ENT', '权限管理', 'apartment', '/ents', 'EntPage', 'ML', 0, 1, 'ENT_UR', 30, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_ENT_EDIT', '按钮： 权限变更', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE_ENT', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_ENT_LIST', '页面： 权限列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE_ENT', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_LIST', '页面：角色列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_LIST', '页面：角色列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_ROLE_SEARCH', '页面：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_ROLE', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER', '操作员管理', 'contacts', '/users', 'SysUserPage', 'ML', 0, 1, 'ENT_UR', 10, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER', '操作员管理', 'contacts', '/users', 'SysUserPage', 'ML', 0, 1, 'ENT_UR', 10, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_ADD', '按钮：添加操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_ADD', '按钮：添加操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_DELETE', '按钮： 删除操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_DELETE', '按钮： 删除操作员', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_EDIT', '按钮： 修改基本信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_EDIT', '按钮： 修改基本信息', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_LIST', '页面：操作员列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_LIST', '页面：操作员列表', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_SEARCH', '按钮：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_SEARCH', '按钮：搜索', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_UPD_ROLE', '按钮： 角色分配', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_UPD_ROLE', '按钮： 角色分配', 'no-icon', '', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_VIEW', '按钮： 详情', '', 'no-icon', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MCH', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
INSERT INTO `t_sys_entitlement_bak` VALUES ('ENT_UR_USER_VIEW', '按钮： 详情', '', 'no-icon', '', 'PB', 0, 1, 'ENT_UR_USER', 0, 'MGR', '2023-08-10 09:30:42.000000', '2023-08-10 09:30:42.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_log
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_log`;
CREATE TABLE `t_sys_log` (
  `sys_log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) DEFAULT NULL COMMENT '系统用户ID',
  `user_name` varchar(32) DEFAULT NULL COMMENT '用户姓名',
  `user_ip` varchar(128) NOT NULL DEFAULT '' COMMENT '用户IP',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  `method_name` varchar(128) NOT NULL DEFAULT '' COMMENT '方法名',
  `method_remark` varchar(128) NOT NULL DEFAULT '' COMMENT '方法描述',
  `req_url` varchar(256) NOT NULL DEFAULT '' COMMENT '请求地址',
  `opt_req_param` text COMMENT '操作请求参数',
  `opt_res_info` text COMMENT '操作响应结果',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  PRIMARY KEY (`sys_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COMMENT='系统操作日志表';

-- ----------------------------
-- Records of t_sys_log
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_log` VALUES (1, NULL, NULL, '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"amVlcGF5MTIz\",\"ia\":\"amVlcGF5\",\"vc\":\"cXpwaA==\",\"vt\":\"YmFkZjNhMzgtODk5Zi00YTM3LWE5NmUtNDUzYjdjZWM0MjBl\"}', '用户名/密码错误！', '2023-08-11 18:25:00.916000');
INSERT INTO `t_sys_log` VALUES (2, NULL, NULL, '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"bTVtcQ==\",\"vt\":\"ZjA3NjI4YjktODZmZS00NzE4LWEyOTYtMTg0Yzg0ZmVjOWJj\"}', '用户名/密码错误！', '2023-08-11 18:25:16.535000');
INSERT INTO `t_sys_log` VALUES (3, NULL, NULL, '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"em14cA==\",\"vt\":\"NGUxMDI5NjQtYTUzMy00OTgxLTk1MjktNzc2NTI0ZWE0MmU0\"}', '用户名/密码错误！', '2023-08-11 18:27:29.698000');
INSERT INTO `t_sys_log` VALUES (4, 801, '超管', '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"bDd0Yw==\",\"vt\":\"ZWE3YmZlMmItZTY5My00ZDczLWE1NmUtYmQ4ZDMzODk5ODdl\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwMV85ZTVmOTdlMS05ZWJhLTQ5YTItYjhlMS05ZmM4NjA5YzY1MmIiLCJjcmVhdGVkIjoxNjkxNzQ5NzU4MDUzLCJzeXNVc2VySWQiOjgwMX0.2ZFMMCfeHRyWjEt9V9jzJBgrbscbQpdgHsNkZ2GA-bHcCwTfg2QDCPNPYRT3R3VhXObW7xrkgnf5fX4m7lyftA\"}}', '2023-08-11 18:29:18.601000');
INSERT INTO `t_sys_log` VALUES (5, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"MTJkdQ==\",\"vt\":\"NjAyMzYzMzAtYjFhZC00ZmQyLTk1NTYtZWZjYTA3OTI1ZmQ2\"}', '请求异常', '2023-08-11 20:55:35.521000');
INSERT INTO `t_sys_log` VALUES (6, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"OXJlNg==\",\"vt\":\"MWFlM2IwMDEtMWVjZC00Y2IzLWEyYjQtOTI4ZWMxMmZhZmU0\"}', '请求异常', '2023-08-11 22:09:10.729000');
INSERT INTO `t_sys_log` VALUES (7, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"cHJvcA==\",\"vt\":\"Mjc1OGZiODYtZjAxMy00NjBjLWE1YWYtYjNhMThmMjY5YWU0\"}', '请求异常', '2023-08-11 22:12:10.393000');
INSERT INTO `t_sys_log` VALUES (8, 803, '超管', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"enVzNw==\",\"vt\":\"ZmNjOTNlOTYtZWI3MS00NTRkLWFhNWUtNDRhOTkxOGIyMmU0\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM182MzE5YzY5Mi0wOGE2LTQ3MWQtYWIzYi0zNGVmZTE0ZGNjY2EiLCJjcmVhdGVkIjoxNjkxNzYzNTM2MTc1LCJzeXNVc2VySWQiOjgwM30.XWLJIx_I8_-WBpJ6kyzrqk6km0vknMj6tyXjoBWgoe01tcskgUq8RYBL3gN4v6d_dRZvnXasggOtcs8FY-YB6g\"}}', '2023-08-11 22:18:57.034000');
INSERT INTO `t_sys_log` VALUES (9, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"amVlcGF5MTIz\",\"ia\":\"amVlcGF5\",\"vc\":\"ZnUydA==\",\"vt\":\"ODAxOGIyMTAtMGFlNy00OWYwLWIyNzMtMTcyYjE5OTU2OWU0\"}', '用户名/密码错误！', '2023-08-11 22:30:27.428000');
INSERT INTO `t_sys_log` VALUES (10, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"ZnUydA==\",\"vt\":\"ODAxOGIyMTAtMGFlNy00OWYwLWIyNzMtMTcyYjE5OTU2OWU0\"}', '用户名/密码错误！', '2023-08-11 22:30:42.082000');
INSERT INTO `t_sys_log` VALUES (11, 803, '超管', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"ZnUydA==\",\"vt\":\"ODAxOGIyMTAtMGFlNy00OWYwLWIyNzMtMTcyYjE5OTU2OWU0\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM19kNmMyOGMxYS1hNDZlLTRkNmMtODk2Ni1hMDQ2ZjczYTdlMWUiLCJjcmVhdGVkIjoxNjkxNzY0MjQ5OTA3LCJzeXNVc2VySWQiOjgwM30.Znu1rZKWTaVFZHhtXFfHKGqrkNjoMlunaOFjaGs69y6bJwC67xv2Z-bSncNUUc2Pv09RloZbXN1owX3W2gM_Yg\"}}', '2023-08-11 22:30:49.925000');
INSERT INTO `t_sys_log` VALUES (12, 803, '超管', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"aDE3eQ==\",\"vt\":\"MzNkN2Y1ZDItYmRhOC00MDJkLWJiZGYtNWRlOWJlMTEwOWE5\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM18yMTkzZjYwYS0yMTBiLTQ2ZjctOTMxMC1iMzg4Y2I1MDg3YzAiLCJjcmVhdGVkIjoxNjkxNzY5NzI0NjI2LCJzeXNVc2VySWQiOjgwM30.ZHQHAF4c9kx9dhYARYw2gWJZE9f0vpTukVlGwv3H6e4-_Y6RTYVMHeEqSThx7XO68_m2ixIrjg-GHBU1qdGMIQ\"}}', '2023-08-12 00:02:04.662000');
INSERT INTO `t_sys_log` VALUES (13, 803, '超管', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"Z2pueQ==\",\"vt\":\"YTBkMTQ4YjItYTVjYS00Nzk5LTk1NDYtZjRhYWI2ODU0ZWRj\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM19lZGMyNjFjNC1kMmRkLTRmZDAtYjI0Ny1kYzJmYzUxMzhmYzciLCJjcmVhdGVkIjoxNjkxNzcxNzkxMTUyLCJzeXNVc2VySWQiOjgwM30._ViESHBN8IeTak-YNJs1EZTC1PAc5FiT661O19bPrvYytsBftPEznonvSrTtl1BcVCevI8jffV7df_MkpyyvqA\"}}', '2023-08-12 00:36:31.160000');
INSERT INTO `t_sys_log` VALUES (14, 803, 'mopay', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"MzNycg==\",\"vt\":\"ZmQ2YTlmNjctYjI3MS00YTA5LTgyOTUtYTRiMjRhZjc3ZTlm\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM18zYjQxMjAxZi1hMThhLTRmOGMtOWQ5NS02N2IzN2VmZDBkMjQiLCJjcmVhdGVkIjoxNjkxNzc0MTcwOTY1LCJzeXNVc2VySWQiOjgwM30.DuULn6cFdmplkbzEOkeItOuVQuCjmrgXBKZqMfWwNvjdLumuU_7-risCngO5czcWr1zgYH-Ord3hIQGA2C52Ow\"}}', '2023-08-12 01:16:11.005000');
INSERT INTO `t_sys_log` VALUES (15, 801, '超管', '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"M2dvNA==\",\"vt\":\"OTg5MTE3YmItMDU5MC00MWVlLWFhNmEtNzBhY2Q3ZWZiMzU1\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwMV9jZmNlODQ4My1lZDg5LTRjMDUtODA1Yi04NzI1ZWQ0ZGMxYzMiLCJjcmVhdGVkIjoxNjkxNzc0NTYxODc1LCJzeXNVc2VySWQiOjgwMX0.WXYueFe9eQn02jvc1Fasq4kPc8m5HC4Ya5P4tDGlsNHA3rdn_MXt0L62uiRpEgD7XuJxLCHbQWp8jIOgfTmx8w\"}}', '2023-08-12 01:22:42.351000');
INSERT INTO `t_sys_log` VALUES (16, 801, '超管', '0.0.0.0', 'MGR', 'com.jeequan.jeepay.mgr.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9217/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdA==\",\"vc\":\"cjl4Yg==\",\"vt\":\"YjJlYzU4NjktMjY5NC00MzFlLWFhNTgtNTU1MTk4N2FlMTM2\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwMV81NDQ5YTQ1Ny05MmQ0LTQ2OTYtYjlhMi1lZTA2OTc0YTcxZWMiLCJjcmVhdGVkIjoxNjkxNzc1NDI0Mjg0LCJzeXNVc2VySWQiOjgwMX0.4w8aUSnFZB01bpCDSVAflRTFSHbCEU63fT4Mp6sPUx2UZawXF-YT1SEETXx7umLCs6e7bYcmY_b79knu40oiOw\"}}', '2023-08-12 01:37:04.300000');
INSERT INTO `t_sys_log` VALUES (17, 803, 'mopay', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"dGVzdDE=\",\"vc\":\"M2MzMQ==\",\"vt\":\"YWZhZjIyODgtY2RlOS00MWQ3LTlmM2MtMDlhOGJkZWQ5NmVl\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzgwM19jNDEyNGQ1OC0wYTQyLTRiMjQtYjY0OS1mYWFmMTk1YWVlODIiLCJjcmVhdGVkIjoxNjkxODEwNjE0OTk0LCJzeXNVc2VySWQiOjgwM30._lSnx4vxBX-bM73Ei4hN_509Ge9fZMHXlL6t7c01aBvCos6tKTTlGjDS2N9nGJMCA5soToa7ZeXAbJoTgevLIg\"}}', '2023-08-12 11:23:35.366000');
INSERT INTO `t_sys_log` VALUES (18, NULL, NULL, '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"MTAwMDA1MDY5\",\"vc\":\"dXJ4cQ==\",\"vt\":\"NmIyNWZiMDUtZWI4OC00YTY3LWEzZDgtNjg3MzZmYTc1MmMy\"}', '用户名/密码错误！', '2023-08-13 22:21:38.443000');
INSERT INTO `t_sys_log` VALUES (19, 203, '100005069', '0.0.0.0', 'MCH', 'com.jeequan.jeepay.mch.ctrl.anon.AuthController.validate', '登录认证', 'http://localhost:9218/api/anon/auth/validate', '{\"ip\":\"MTIzNDU2\",\"ia\":\"MTAwMDA1MDY5\",\"vc\":\"ODQxcw==\",\"vt\":\"ZGFmOTY0NTYtZWE0Ni00ZDY1LWIyMWUtMzk0NDYzNWFkN2Q0\"}', '{\"msg\":\"SUCCESS\",\"code\":0,\"data\":{\"iToken\":\"eyJhbGciOiJIUzUxMiJ9.eyJjYWNoZUtleSI6IlRPS0VOXzIwM18wNWMyNjQ2YS01ZWY2LTQ4OWUtOTNiMi02M2I0MGRhNWE1NzMiLCJjcmVhdGVkIjoxNjkxOTM3NDA0Mjk5LCJzeXNVc2VySWQiOjIwM30.ljR6eSufhqupvK7mMPzWJc0fZvxDuCl8zaSuY1nwvmnPPbjLpzn8SiAf1_D1Yij2ZfsDAGYjmgZkenZVDh-cfg\"}}', '2023-08-13 22:36:44.644000');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
  `role_id` varchar(32) NOT NULL COMMENT '角色ID, ROLE_开头',
  `role_name` varchar(32) NOT NULL COMMENT '角色名称',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  `belong_info_id` varchar(64) NOT NULL DEFAULT '0' COMMENT '所属商户ID / 0(平台)',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统角色表';

-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role` VALUES ('ROLE_ADMIN', '系统管理员', 'MGR', '0', '2021-05-01 00:00:00.000000');
INSERT INTO `t_sys_role` VALUES ('ROLE_OP', '普通操作员', 'MGR', '0', '2021-05-01 00:00:00.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_role_ent_rela
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_ent_rela`;
CREATE TABLE `t_sys_role_ent_rela` (
  `role_id` varchar(32) NOT NULL COMMENT '角色ID',
  `ent_id` varchar(64) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`role_id`,`ent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统角色权限关联表';

-- ----------------------------
-- Table structure for t_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
  `sys_user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '系统用户ID',
  `role_id` varchar(128) DEFAULT NULL COMMENT '角色id',
  `login_username` varchar(32) NOT NULL COMMENT '登录用户名',
  `realname` varchar(32) NOT NULL COMMENT '真实姓名',
  `telphone` varchar(32) NOT NULL COMMENT '手机号',
  `sex` tinyint(6) NOT NULL DEFAULT '0' COMMENT '性别 0-未知, 1-男, 2-女',
  `avatar_url` varchar(128) DEFAULT NULL COMMENT '头像地址',
  `user_no` varchar(32) DEFAULT NULL COMMENT '员工编号',
  `is_admin` tinyint(6) NOT NULL DEFAULT '0' COMMENT '是否超管（超管拥有全部权限） 0-否 1-是',
  `state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '状态 0-停用 1-启用',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  `belong_info_id` varchar(64) NOT NULL DEFAULT '0' COMMENT '所属商户ID / 0(平台)',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '角色id',
  PRIMARY KEY (`sys_user_id`),
  UNIQUE KEY `sys_type` (`sys_type`,`login_username`),
  UNIQUE KEY `sys_type_2` (`sys_type`,`telphone`),
  UNIQUE KEY `sys_type_3` (`sys_type`,`user_no`)
) ENGINE=InnoDB AUTO_INCREMENT=804 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户表';

-- ----------------------------
-- Records of t_sys_user
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user` VALUES (801, '', 'jeepay', '超管', '13000000001', 1, 'https://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/defava_m.png', 'D0001', 1, 1, 'MGR', '0', '2020-06-13 00:00:00.000000', '2023-08-11 10:31:21.296657');
INSERT INTO `t_sys_user` VALUES (802, '', 'test', '超管', '13000000002', 1, 'https://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/defava_m.png', 'D0002', 1, 1, 'MGR', '0', '2020-06-13 00:00:00.000000', '2023-08-11 17:24:04.601498');
INSERT INTO `t_sys_user` VALUES (803, NULL, 'test1', 'mopay', '13000000003', 1, 'https://jeequan.oss-cn-beijing.aliyuncs.com/jeepay/img/defava_m.png', 'D0003', 1, 1, 'MCH', '0', '2020-06-13 00:00:00.000000', '2023-08-11 17:02:31.777134');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_auth
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_auth`;
CREATE TABLE `t_sys_user_auth` (
  `auth_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` bigint(20) NOT NULL COMMENT 'user_id',
  `identity_type` tinyint(6) NOT NULL DEFAULT '0' COMMENT '登录类型  1-登录账号 2-手机号 3-邮箱  10-微信  11-QQ 12-支付宝 13-微博',
  `identifier` varchar(128) NOT NULL COMMENT '认证标识 ( 用户名 | open_id )',
  `credential` varchar(128) NOT NULL COMMENT '密码凭证',
  `salt` varchar(128) NOT NULL COMMENT 'salt',
  `sys_type` varchar(8) NOT NULL COMMENT '所属系统： MGR-运营平台, MCH-商户中心',
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=804 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户认证表';

-- ----------------------------
-- Records of t_sys_user_auth
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_auth` VALUES (801, 801, 1, 'jeepay', '$2a$10$WKuPJKE1XhX15ibqDM745eOCaZZVUiRitUjEyX6zVNd9k.cQXfzGa', 'testkey', 'MGR');
INSERT INTO `t_sys_user_auth` VALUES (802, 801, 1, 'test', 'e10adc3949ba59abbe56e057f20f883e', 'testkey', 'MGR');
INSERT INTO `t_sys_user_auth` VALUES (803, 803, 1, 'test1', 'e10adc3949ba59abbe56e057f20f883e', 'testkey', 'MCH');
COMMIT;

-- ----------------------------
-- Table structure for t_sys_user_role_rela
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role_rela`;
CREATE TABLE `t_sys_user_role_rela` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` varchar(32) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作员<->角色 关联表';

-- ----------------------------
-- Table structure for t_transfer_order
-- ----------------------------
DROP TABLE IF EXISTS `t_transfer_order`;
CREATE TABLE `t_transfer_order` (
  `transfer_id` varchar(32) NOT NULL COMMENT '转账订单号',
  `mch_no` varchar(64) NOT NULL COMMENT '商户号',
  `isv_no` varchar(64) DEFAULT NULL COMMENT '服务商号',
  `app_id` varchar(64) NOT NULL COMMENT '应用ID',
  `mch_name` varchar(30) NOT NULL COMMENT '商户名称',
  `mch_type` tinyint(6) NOT NULL COMMENT '类型: 1-普通商户, 2-特约商户(服务商模式)',
  `mch_order_no` varchar(64) NOT NULL COMMENT '商户订单号',
  `if_code` varchar(20) NOT NULL COMMENT '支付接口代码',
  `entry_type` varchar(20) NOT NULL COMMENT '入账方式： WX_CASH-微信零钱; ALIPAY_CASH-支付宝转账; BANK_CARD-银行卡',
  `amount` bigint(20) NOT NULL COMMENT '转账金额,单位分',
  `currency` varchar(3) NOT NULL DEFAULT 'cny' COMMENT '三位货币代码,人民币:cny',
  `account_no` varchar(64) NOT NULL COMMENT '收款账号',
  `account_name` varchar(64) DEFAULT NULL COMMENT '收款人姓名',
  `bank_name` varchar(32) DEFAULT NULL COMMENT '收款人开户行名称',
  `transfer_desc` varchar(128) NOT NULL DEFAULT '' COMMENT '转账备注信息',
  `client_ip` varchar(32) DEFAULT NULL COMMENT '客户端IP',
  `state` tinyint(6) NOT NULL DEFAULT '0' COMMENT '支付状态: 0-订单生成, 1-转账中, 2-转账成功, 3-转账失败, 4-订单关闭',
  `channel_extra` varchar(512) DEFAULT NULL COMMENT '特定渠道发起额外参数',
  `channel_order_no` varchar(64) DEFAULT NULL COMMENT '渠道订单号',
  `err_code` varchar(128) DEFAULT NULL COMMENT '渠道支付错误码',
  `err_msg` varchar(256) DEFAULT NULL COMMENT '渠道支付错误描述',
  `ext_param` varchar(128) DEFAULT NULL COMMENT '商户扩展参数',
  `notify_url` varchar(128) NOT NULL DEFAULT '' COMMENT '异步通知地址',
  `success_time` datetime DEFAULT NULL COMMENT '转账成功时间',
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  PRIMARY KEY (`transfer_id`),
  UNIQUE KEY `Uni_MchNo_MchOrderNo` (`mch_no`,`mch_order_no`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='转账订单表';

SET FOREIGN_KEY_CHECKS = 1;
